I have a database which relies heavily on a scanned item number (non repeating and NOT a primary key) which needs to be entered into 4 tables, to save time I was wondering if it can be entered into the main table and autopopulated into the remaining three tables?
I am very new to access so...