M
macca
Here is a database structure I am working with - but I am having trouble
coming up with a good interface for the processing of new orders.
Clients Orders OrderDetails Items
CustNo (1) OrderNo (1) (M) OrderNo (1) ItemCode
FName (M) CustNo ItemCode (M) NameDesc
SName Date NumItems Desc
Address Value
etc
I have a good Main form interface based on Clients i.e. with a subform
comprising Orders which then has a subform showing Orderdetails. This means
I can scroll from Customer to Customer - and see the orders and order
details. If I want to I can add, edit Customers - I can quickly "see" how to
add the order dertails. I assume this is because the Main form is based on
Clients - and the subforms work out because of a 1 to Many relationship
between Clients and Orders - and then another 1 to Many relationship between
Orders and OrderDetails i.e. there is a sort of nesting of subforms.
What I want to know is - can I have a data entry form which is essentially
based on the Orders table i.e. the Main form is based on Orders. But I want
it to allow me to scroll through the Orders and if I want to add a new
record - I want to "see" the Customer details rather than just have to know
their IDNo. Every attempt I have made has failed to see this connection.
I assume this is because when I start with the Orders form it is actually a
Many to 1 relationship when going back to Clients.
Any advice?
coming up with a good interface for the processing of new orders.
Clients Orders OrderDetails Items
CustNo (1) OrderNo (1) (M) OrderNo (1) ItemCode
FName (M) CustNo ItemCode (M) NameDesc
SName Date NumItems Desc
Address Value
etc
I have a good Main form interface based on Clients i.e. with a subform
comprising Orders which then has a subform showing Orderdetails. This means
I can scroll from Customer to Customer - and see the orders and order
details. If I want to I can add, edit Customers - I can quickly "see" how to
add the order dertails. I assume this is because the Main form is based on
Clients - and the subforms work out because of a 1 to Many relationship
between Clients and Orders - and then another 1 to Many relationship between
Orders and OrderDetails i.e. there is a sort of nesting of subforms.
What I want to know is - can I have a data entry form which is essentially
based on the Orders table i.e. the Main form is based on Orders. But I want
it to allow me to scroll through the Orders and if I want to add a new
record - I want to "see" the Customer details rather than just have to know
their IDNo. Every attempt I have made has failed to see this connection.
I assume this is because when I start with the Orders form it is actually a
Many to 1 relationship when going back to Clients.
Any advice?