Form Help

[MTSPEER]

I currently Have 3 tables. And I want to put all 3 tables into one form. Is it possible to do that?

[JoeM]

There are two options, it is dependent upon what you are trying to do.

1. If there is a relationship between the tables, join the tables together in a query, adding the fields you want to display, and then use the query as the data source of your Form.
2. If they are unrelated and you just want to show them all, create three separate Subforms, and then place all three of those Subforms on your main Form.

[MTSPEER]

I made them related to each other. But it said I can't but primarys keys in? But I'm new to this so I don't really know how to write a query for that. My table names are [Health Plan], [Survey Info], and [Customer].

[JoeM]

You would need to describe for us how the tables are related to each other.

Are you saying you are trying to make a certain field a primary key in your underlying table and it won't let you?
Remember, primary keys must be unique, and non-blank within a table.
You can always add an autonumber field to each of your tables if you do not have a natural primary key field. You probably wouldn't be using it in any of your joins.

[MTSPEER]

In all 3 of my tables I have the customer's Unique ID number and the customer's name so I can find the right record to input data. I can't put the ID number as the primary key for all 3 tables.

[JoeM]

I can't put the ID number as the primary key for all 3 tables.

Why not? Is it because they may appear multiple times in certain tables (so they are not unique in that table)?
You can add Autonumber fields (like I said) to those tables if you want primary keys.
However, I don't think you need primary keys to join those tables in a query anyway. You should be able to join them all on your common field.

[MTSPEER]

Okay thanks. But back to the query help for the form. How would I join all 3 tables in a form using that query.

[JoeM]

Create a query linking those three tables, and selecting to show all the fields you want to display on your Form.
Then create the Form off of that Query (not the tables!). So the Query is the Record Source of your Form (not any Tables).

If you know how to create a Form from a single table, it works exactly the same way. You are just starting from a Query instead of a Table.

[MTSPEER]

Okay thanks. I was just given another project. I have to create a form with entries like member name, ID number, Contact Phone, fax. And I want to add a combo box. But I have no data. I want to create the form. and each individual record i make in the form I want it to save the data in a table. Is that possible? Do I make fields first in a table then create a form? I tried that, and whenever I create the first record then go to the next one the same infomration is kept for the next form which I dont want. The combobox information stays the same for every record

And I Want to keep the Phone Number and Fax the same for every record

[JoeM]

You have been having a few of them today. Is it some sort of school project or homework assignment?

It is usually best to post brand new questions in new threads. That way if I don't have the answer, someone will see it is an unanswered question.

[MTSPEER]

I am intern at a health insurance company. And I just posted it in a new thread. My database class at college was worthless..didn't use access at all

[JoeM]

My database class at college was worthless..didn't use access at all

Really, was it just theory then?
Hopefully, they at least hit on topics of Relational Databases like the the Rules of Normalization and Database Design. Those are very important to have a good handle on when creating databases.

[MTSPEER]

We didn't really go over structure. I get the whole entities, attributes, primary key and foreign key thing. We basically just used Oracle