By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,948 Members | 663 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,948 IT Pros & Developers. It's quick & easy.

Subform

P: n/a
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.

Aug 13 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Aug 13 '06 #2

P: n/a
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.
Aug 13 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.