Hello,
Is it possible to have a master Access table where I can type in customer ID, account name, account ID, and description and then have these fields autopopulate in other tables since they would contain the same information? I came in late to project so database design isn't perfect and I now need to figure out a workaround. Any ideas on how to go about doing this? Also, I don't want past information to be added to the other tables. Only the new information that is entered.
Thanks