How to show(transfer) fields from a table to another one

[royaro]

Hello all,

I'm new to Access and I'm not exactly sure if the topic makes sense, but I will try to explain.

My workplace uses mostly two tables. One to track all visitors, and one to track the monthly progress of visitors who register to receive our services.
I want to do two things.
1st. Make that te names of those clients marked as registered move automatically to the second table.
2nd. Both tables have 6-7 fields (out of 16) that contain the same information. I want to transfer the information of those fields from the All clients table to the Registered table, instead of needing to type again the same information.



On my database each visitor has an ID which is the primary key for the All visitors table, and I have a field where we check when the clients register. I'm okay with not having all the fields repeated, but I would really like to find the way to find the answer to the first idea.

Thank you,

[CJ_London]

think you need to learn about normalisation - what you have at the moment is basically the equivalent of two spreadsheets.

Not enough info to provide a proper solution but suspect you need your data organised into

tblVisitors
VisitorPK autonumber
…. - remaining fields from your 6-7
….
registered yes/no

tblServices
ServicePK
ServiceName


tblServicesUsed
ServUsedPK
VisitorFK
ServiceFK
DateUsed


Then you can use queries to display the data you want

[royaro]

Thank you. Like I mention I'm new and I'm trying to move from Excel with two existing tables. You gave me something to start with . I appreciate the help!