auto fill some fields

[gtsek]

Hi. I have 2 tables , first has people details , 2nd has these people visit (mob number , name surname there is in both tables and mobile is relationship one to many). I need when in 2nd table i put the phone , name and surname auto filled

Thanks

 

[Joe4]

Welcome to the Board!

Typically, you wouldn't have BOTH mob number and surname in the both tables. You don't want situations where if a value changes (like surname), it needs to be changed in both tables, and you typically do not want key fields that you join on to be fields in which values can change. So I would recommend just keeping surname in the "people details" table, and remove it from the other.

To further to that extent, you typically do not want to store the other information in multiple tables - unless the information may change and you are trying to track it for historical purposes. Typically, you would just join the two fields in a query, and return all the fields that you want to see in the query (so if there is no need to track what the data was at an exact point in time, there is no need to store it in the other table also).

 

[gtsek]

Welcome to the Board!

Typically, you wouldn't have BOTH mob number and surname in the both tables. You don't want situations where if a value changes (like surname), it needs to be changed in both tables, and you typically do not want key fields that you join on to be fields in which values can change. So I would recommend just keeping surname in the "people details" table, and remove it from the other.

To further to that extent, you typically do not want to store the other information in multiple tables - unless the information may change and you are trying to track it for historical purposes. Typically, you would just join the two fields in a query, and return all the fields that you want to see in the query (so if there is no need to track what the data was at an exact point in time, there is no need to store it in the other table also).

I need these fields (name - surname ) for confirmation... I think that i can use 2 labels and i am looking for code like
Private Sub kinito_AfterUpdate()
Label1.Caption =
label2.caption =
End Sub

 

[Joe4]

I need these fields (name - surname ) for confirmation... I think that i can use 2 labels and i am looking for code like
Private Sub kinito_AfterUpdate()
Label1.Caption =
label2.caption =
End Sub

I am sorry. I do not understand what you are stating/asking here, or how it applies to what you quoted from me.