Forms/Queries and Data OH My!!

[zym1ne]

Hoping might find some help here, on what's most likely newbie stupidity!!!

Totally new to Access both as user and designer and muddling through...problem I have though is that can't seem to produce a query or report that I require.

I have a DB that I would like to keep track of Dealers(Car) work requests, work done on their PC's and their PC details.
I have the tables prepared...

tblDealersMain (holds all Dealer info. with P.Key a unique assigned number they are given...called DID)

tblWorkRequests (speaks for itself)

tblPCDetails

tblAdmin

tblSales

i'm trying to produce a form that when the DID is entered will automatically bring up the Dealers details such as address/phone/post code so that i am not required to search for these details myself, this is for the Work Requests and Admin which are 2 seperate entities but require the same inputed info...
Everything i've tried so far has fallen well short of what i desire
I have managed to produce a Query that will show an individual Dealers details but cannot change this into a form that will allow entry of another DID...i dont want to update any fields in the Dealer table just have a form that allows me to find the correct info for a Dealer by his DID then allow me to assign Work Requests and Admin details either on a form activated by a command button or some such...

Maybe what i have tried to explain here is a litle convaluted but hoping i might find some help for this as i've now lost all my hair in a attempt to work this out.

cheers folks

 

[KingKong]

Hi zym1ne,

I've attached a simple db to show you how to do this (well that is off course if I got your question right ).

It's just a form which has a combobox on it where you can select the DealerID. Once you've selected the ID, the details are shown in a sub-form.

Open frmDealersInfo to have a go at it.

Grtz,

Peter.

 

[zym1ne]

RE Db1

Thx Peter

Had come round to something similar to this solution, problem i'm having still is that i cant figure out how to enter the DID in an actual form rather than pop-up (pop-up meaning when u run the query and it requires u input the DID in the box that appears)...

For instance I have created a frm via a query on the TblDealersMain but when I have created a table from this query and you have the choice to enter the DID it:

1. Believes I'm trying to update/create a new record and an error reads that I cannot create a record with a duplicate DID...?

2. Cannot get the Address/Contact fields to update dynamically on the form via entering the DID number.

Great place to start with the idea of a sub-form though, any other suggestions to the above points would be very greatfully recieved.

Many thanks and if you have any other advice would be great!!!!

zym