[willadene]

2000 Outlook was installed on the computer but for some reason when customizing Outlook Today the customize button does not work. Any suggestions.

2000 Access

I have two tables that I want to build into a form. I have a common key between the tables which is the combination of two identical fields from each of the two tables but for some reason, I cannot pull these 2 tables into 1 form.

Thanks.

 

[Ziggy1]

For Access:

I'm going to assume one table is a Header and the other is a detail, with this in mind you would want to build a form with a subform.

Create a form based on the header "Type" table.

Then in design view resize the window so you can see the DB window beside the form.

Click on the table that contains the "Details" and drag it to the form (below the other fields). This should launch the Subform wizard, you can choose the fields that relate and if I guessed right it should do what you need.

Post back if any problems, again the "Header/Detail" I refer to is essentially a One to many relationship.

 

[MustBNuts]

Another option is to first create a query involving both tables. Run the query to make sure it is pulling the pertinent info, and when you are happy with the data output, you can create a form based on that query.

Hope this helps,

MBN