Making a form?

  • Thread starter Thread starter Marco Simone
  • Start date Start date
M

Marco Simone

Hi,

I am beginner in access and I have problems with making form.
I have 4 tables in database.
1 and 2 table are in relationship "one to many", and 3 and 4 table also in
relationship "one to many". All tables have primary keys. I have put
autonumber primary key for every table.
I have trouble with making form for entering data into tables.
1. Do I have to put primary key field into form? I thought that I don't have
to put that field since it is autonumber field, so that primary key field
doesn't confuse user.
2. Can I put on form fields from tables that are not in a relationship? I
would like to have one form with text boxes to enter data in all 4 tables.

Thanks for your answers.
 
Marco Simone said:
Hi,

I am beginner in access and I have problems with making form.
I have 4 tables in database.
1 and 2 table are in relationship "one to many", and 3 and 4 table also in
relationship "one to many". All tables have primary keys. I have put
autonumber primary key for every table.
I have trouble with making form for entering data into tables.
1. Do I have to put primary key field into form? I thought that I don't have
to put that field since it is autonumber field, so that primary key field
doesn't confuse user.
2. Can I put on form fields from tables that are not in a relationship? I
would like to have one form with text boxes to enter data in all 4
Click to expand...
tables.

I'm afraid "I have trouble..." is not enough to go on. What exactly are
the problems? If you are binding the form to a query containing multiple
tables this will often not work. You likely need a main form/sub form
arrangement so each form is bound to a single table.
 
Back
Top