aliasquark
Registered User.
- Local time
- Today, 10:02
- Joined
- Dec 2, 2002
- Messages
- 14
I have a Form set up which populates a table and distinguishes records according to Customer Number and Order Number.
When I go into the order for all Records are there.
How do you restrict a form to show only the customer records and order number that is relevant (i.e. as shown in the customers form which is opened at the same time)
In SQL terms it would be something along the lines of:
SELECT * FROM T-Orders
Where CustomerNumber = X AND OrderNumber = Y
Does something like this exist for filtering form information?
When I go into the order for all Records are there.
How do you restrict a form to show only the customer records and order number that is relevant (i.e. as shown in the customers form which is opened at the same time)
In SQL terms it would be something along the lines of:
SELECT * FROM T-Orders
Where CustomerNumber = X AND OrderNumber = Y
Does something like this exist for filtering form information?