Best database setup?

[joce]

Hi,

I am creating a farm audit database, and so that i can go through the whole audit for a single farm I am using tab control forms. (I hope this is the right thing to do)

But i want it so that at the top of the page you enter the customers name and date, and then work your way through the forms on the tab control to fill in the data.

But I am wondering how do I go about entering new customers. Should my customers form be within the Tab control or should it be seperate and put all my tab controls into that form. If that makes sense to you?

Any help would be appreciated

Joce

 

[Alansidman]

I would put the customer and its key information on the main form (own table). I would make the tabs subforms on the main form. This should contain your audit data.

 

[joce]

Is it ok to have 2 copies of the Customer form, i.e. one that could be used for new customers and one that sits in the tabs subform aswell for current customers to look back at their information?

Or is this a pointless idea?

 

[Alansidman]

I see no reason to have two forms. You could build a custom filter as shown in the following to look up details.

http://www.datapigtechnologies.com/flashfiles/buildcustomfilter.html

You could enter new data using the existing form.

Alan