Do I use all fields in a table in the new form; specifically IDs

[Acesscylc2019]

I’m new to designing a database and using Access. Im designing a new version of one we use that is currently mostly coded using VBA and has many layers of exported data from other dbs over the years which means there is IDs, previous IDs and prev prev IDs which are required to export the data... Ive designed my dB and have created all the tables and linking tables which incorporated all the previous IDs I need to import some of the old data into The new one. I’m up to creating the forms and wondered if all the various IDs that link the data need to be brought over into the form (for example, the client table has ID, Prev ID, Prev Prev ID for each person....sorry to sound so ignorant; I’m learning on the fly and need some help

[CJ_London]

forms have recordsources - typically a table - just bring through what you need for that form to work. No need to bring everything through if not required

for example, the client table has ID, Prev ID, Prev Prev ID for each person

typically if you have a history of multiple ID's you would use one as your primary ID and the others as aliases

tblPeople
PeoplePK...fld1...fld2 etc
1...........Harry.White
2...........Fred..Jones

tblSources
SourcePK..SourceName
1.............HR system
2.............CRM system


tblAliases
SourceFK...Alias....PeopleFK
1..............HW1.....1
1..............FJ1.......2
2..............0123.....1
2..............0345.....2