Subform

Switchwork

Registered User.
Local time
Today, 22:31
Joined
Dec 1, 2003
Messages
81
Hi all long time no write.

I designed the database but would like to attempt a better made one. Basically I would like something like the sample database on clients and orders.

You know Clients details at the top and there orders or in my case jobs we have done for them (courier company) at the bottom in a type of table subform thing.

Firstly I would like to know if this is hard to do, and secondly how to go about doing it. As i have said I have already designed a database for the company but I would like to do it a bit better now I have an idea what I am doing I would like to try and acheive a better designed database as I know that mine could be alot better. E.G my main table TbleJobDetails has 23 fields.

Any tips and advice would be gratefully appreciated.

Thankyou
 
Switchwork

This isn't difficult, especially with all of the helpful people on this forum. You'll need 2 tables, TblClients, which will store the name of the client. Your main form will be based on this table and TblJob, which will store each of the jobs that have been done for the client. The subform will be based on this table.

The tables could look somthing like this:

TblClient
ID - autonumber field and primary key
ClientName - text field
any other details you need about the client i.e. contact details will also go in this table.

TblJob
ID - autonumber field and primary key
ClientName - lookup field from TblClient
Jobdetails etc.

When you insert the subform onto the form, Access will suggest possibilities of the master and child fields, which link the 2 tables (i.e. the client to the jobs). This will allow you to display the specific jobs for each client.
 

Users who are viewing this thread

Back
Top Bottom