Producing Linked Table Forms...?

[zym1ne]

Hi folks hoping can find some help here...

Still muddling through slowly trying to create first real DB and would really be thankful for some help on this one...

I have 5 tables in my DB

1. tblDealers
2. tblPCdetails
3.tblWorkRequests
4.tblAdmin
5.tblSales

tblDealers is the Main table consisting of all my primary info. such as a unique ID# address, name, etc...
tables 2-4 are linked to tblDealers using the DID field (unique ID#)
With some help from earlier today I have managed to create a search form that opens a 2nd form containing all the data i require from the dealers table, is it possible to produce a form that enables me to find any info relating to an individual Dealer via the DID or Clients name and display it in a seperate form that could pop-up?

i.e: say I want to find all work requests for a particular Dealer, or all Admin work carried out for a dealer and for this info to be presented in form format?

And in relation to Admin is it possible to search by date the work was carried out, as this is a required field within my table?

Any help on these would be great, have'nt found much to help me on this via books at moment and starting to drive family wild

many thanks for any feedback on this folks

 

[pono1]

Yes, you can set up a search form to do this. But you may want to first explore the possibility of setting up nested subforms (and perhaps a tab control).

Just consider the work requests for now and picture this on your screen: dealer record details at the top of your form while at the bottom there is a list of all of the work requests for that dealer. (Or, with a tab control, you could put work requests on another "page" of the same record -- accessible by clicking a "tab" or a button.)

When you move to another dealer record, the work requests for this "new" dealer record automatically appear.

To the user it looks like one form but in Access parlance you have a main and subform, working together, syncing the records in two tables that are in a 1-to-many relationship.

Regards,
Tim

 

[zym1ne]

sounds ideal...

Thanks for the response Tim!!

That sounds ideal ...and now time to ask exactly how i would acheive this?

Not 100% sure how I would create these nested subforms or tab controls...and be able to dynamically update the dealer details so that I could acheive this.

Would this involve creating a further search form and placing the subforms upon this? or some other way?

Sorry to sound stupid here but still rather inexperienced in the use of Access, is it then possible to enter a DID# at the top of the screen and have all relevant records update automatically below (i.e Dealer details, work requests, etc...).

Any further pointers on how to acheive this would be very appreciated.

Many Thanks again

zym

 

[pono1]

Z,

In my Access 2K Help file, there is quite a bit of info on subforms so if you haven't already looked up "subform" in Help, I recommend you do so.

Additionally, search your computer for a file called Northwind.MDB -- it's a sample DB that comes with Access and it does have a nested form/subform that you can examine.

Also, here's another post on how to set a simple nested main and subform. If practice makes perfect, you may want to experiment working with nested subforms in a test file (I would initially keep it simple and separate from your Search Form idea) trying out various scenarios until you're comfortable, perhaps even going back and re-reading the Help file after a few hands-on attempts.

The mildly incredible thing -- no code is needed to pull this off.

Regards,
Tim

 

[zym1ne]

Thanks for those pointers will have a look and see what I can come up with, and if a newbie like me can get away without using code at the moment all the better

Will let you know how things work out.

Thanks for the help Tim

Zym