Forum Discussion
Linking data on tables
Hi I am very new to access, and watching lots of videos at the moment. I wondered though does anyone know how I can get two bits of information onto every table. I need the unique ID that access...
Tell us more about the service. What is it? How does it generate codes? Should every record in every table have a unique service code?
Gerrit_Viehmann yea everyone in the service gets a unique number which is always theirs and never changes. People can come in and out the service but that is always their number. So we need something else to represent point in time - which we think could be the automated access number which we would call a referral number. So we have a main table - but we need the two numbers (the first two columns) to be copied to each table when a new row is added. Does that make sense?