Subform

[Eric]

I have three tables in my database. One is main, rest of them i want to
use as a sub form in tabular format in main form. I have no experience
in creating subforms. Can any one please help me step by step how to i
create subform in my main form.

Table Customer (Primary)
Table Invoice (Child)
Table Voucher (Child)

2nd do i create links between all of these table when i create tables
or in the form level.

Thanks in advance.

[Sean Tierney]

Eric wrote:

>Can any one please help me step by step how to i
create subform in my main form.

2nd do i create links between all of these table when i create tables
or in the form level.

You do not need to link the tables as such, but there needs to be an
identifier in the child table that refers to the master table i.e.
MasterID etc.

Create the form drawng data from the child table (you can use the
wizard) and include on the child table the field that links to the
master table. Create the form for the master table in the same way.

Then drag the child form from the db window to the open master table
form (in design mode) and drop. Access will ask you to identify the
linked fields (or you can do this in the forms properties function).
Have a look at the Nothwind example where this is very clear.

Your "child" form can have another subform done in exactly the same way.

Good luck

Sean

[Eric]

I create subform of invoice in customer form when i run the form it
gives that error what does it means?
Index or primary key can not contain a null value

Second in invoice form there is a variable name item which should be
linked with the item table I need help how to create link in invoice
table with item table and then how to i create a drop down in invoice
form of items

Thanks in advance.

Eric wrote:

I have three tables in my database. One is main, rest of them i want to
use as a sub form in tabular format in main form. I have no experience
in creating subforms. Can any one please help me step by step how to i
create subform in my main form.

Table Customer (Primary)
Table Invoice (Child)
Table Voucher (Child)

2nd do i create links between all of these table when i create tables
or in the form level.

Thanks in advance.