I need help with joining table for an order form to be based on

[Guest]

I am having the hardest time trying to figure out how to make an order form
that will list Supplier info automaticly when the supplier id is entered in.
My order table has 3 fields that are primary keys in other tables. I have
tried many different joins with queries and still cant get what i want
.......Please help me

 

[Van T. Dinh]

Have you checked the sample database "NorthWind" that comes with your Access
software (it may / may not be installed on your PC)?

IIRC, in the "Order Form", it has the arrangement similar to what you need.

 

[Guest]

Have you checked the sample database "NorthWind" that comes with your Access
software (it may / may not be installed on your PC)?

IIRC, in the "Order Form", it has the arrangement similar to what you need.

--
HTH
Van T. Dinh
MVP (Access)







Yes I can join tables in query to list the info i want to see ......

i have even downloaded sample forms and i am still not able to see how to
get it to list on form

my order table is as follows:

Supply Order Id primary key
Supplier Id foreignkey
Employee Id foreign key

i want to have a form to enter new orders and fill in the supplier name and
address and the employee name and still be able to enter new records.

i have tried a join between supply order and supplier tables ....i have
tried even to make table from that query.....when i make a form it wont let
me imput anything even with the form set to un dynamic ........i am really
frustrated with this....lol

 

[Van T. Dinh]

Have you checked the NorthWind database as I wrote???

I had a quick look and it seems to me the Form "Orders" which has the Query
"Orders Qry" as the RecordSource is the arrangement that you need. The only
difference is that your Supplier is equivalent to Customer in the sample
database.

 

[Guest]

I am having the same problem... as you did you find a solution...
I have client list with name address phone etc. and then I have created
work dockets as jobs come in and I want to transfer the name etc without
having
to type them again but can't seem to figure it out...
Desperatly need help Queenierules

 

[Van T. Dinh]

(same answer as replied to original post. Re-posted here just in case you
didn't find the reply)

Have you checked the NorthWind database as I wrote???

I had a quick look and it seems to me the Form "Orders" which has the Query
"Orders Qry" as the RecordSource is the arrangement that you need.