Forms & Tabs

[sarny]

I've only been using Access for a week or so &teaching myself. I have two tables, one with company information and one with client information, i want a form that will enable the user to enter the company information on the 1st tab, then the clients on the 2nd. I have created both forms seperately already but can find no way 2join them. Please help i have only a few days 2impress the boss!

 

[Rich_Lovina]

It sounds like you have created the form based upon your two tables only. In Access you need to 1) Link your tables and define a relationship between them. Use relationships key at first.
2) Click query-new-design, open your two tables (the join you created will pop-up automatically).
3) Learn then how to use select query, and how to place all the fields you want on yr form in the design grid.
4) Now you are ready to design a form showing fields from linked tables.

If this is your first experience with Dbase packages i doubt all this is achievable in two days, but give it your best shot, trial and error and lots of reading the Help options, and study the sample Northwinds Database, esp in Design views.

Good Luck, you'll get there.