469,955 Members | 2,544 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,955 developers. It's quick & easy.

Date Field ---Help

Ken
I have 2 forms I am using for delivery dates. One is the regular order
form and the other is the repair form.
I am attempting to make a field in my schedule from the querys from
these forms that lists all the deliveries from such as june 5
combining the deliverydate from orders and deliverydate from repairs
The pk in orders is job number and itis the fk in repairs.
repair number is pk in repairs form
thanks in advance for any input

Nov 13 '05 #1
1 1062
Normal way to model this or do a form for it is a mainform/subform,
where the main form is based on the parent table (PK), and the subform
is based on the child table (the one with the FK).

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Ralph Freshour | last post: by
1 post views Thread by Liz Malcolm | last post: by
1 post views Thread by Graham Feeley | last post: by
4 posts views Thread by andrewbda | last post: by
7 posts views Thread by sheri | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.