So I have a table 'TableA' that has unique part number on it. 'TableB' is a certain category of parts. 'TableC' is a different category. What I would like to happen is every time a new part is created on 'TableB' or 'TableC' a unique record is created on 'TableA' and pushes the part number to the table. That record in TableA would then be 'blocked off' and the next record that would be created would make a new unique record in TableA
I am sure that this is an Access 101 question but I can't seem to figure it out.
Thanks,
M.S.