Search results

I have two tables that overlap...that is, they contain some identical fields with identical data. How can I make my one form fill in both tables? Ex. Each table contains the ID#s for all my clients. Is there a way I can enter each ID into the form and have it filled in in both tables...

I tried to add a new record to my table, but it doesn't show up on the corresponding form. If I try to add it to the form, I'm told one of my fields is prohibited by the validation rule. The validation rule is >=010001 and <=019999. I'm entering 010035, and it's telling me it's prohibited...

I'm rather new to Access, but I have to get this done fast. I have two separate databases: one in table form with all my records and fields; and another that is empty, with the exception of 3 preformatted forms and corresponding tables. My employer wants me to transfer all data from database 1...