Hi, I’m a database novice. I’m doing a survey on fishermen, the gear they use and their opinons about how things have changed over time. I’ve set up a main table with a primary key auto number per fisherman. I want that ID number to automatically come up in the subsequent tables about their vessels, opinons and gear. I’ve had a look at the forum and I’m sure there must be something in there, I just haven’t found it yet!
I’ve linked the ID number in a “one to many” relationship (one to one would also work? ie. Only one address per fisherman) from the main table to the rest of them. My plan was that as I entered the data in the subsequent tables the fisherman ID number would be there automatically.
Thanks,
Mark