O.K. Here is my scenario, I am creating an order form for my business, and I want a locked field that will be called order #. I want this field to display the primary key from my sales table, so that for every new sale I will have a new order number(for record identification).
My prblem is that on this form I already have the record source set as my "consumer information" table. Therefore I cannot view the records from 2 different tables on the same form. is there a way around this?
Realize, since the forms recordsource in based on [blue]consumer information[/blue] and not the table containing the sales primarykey, the form has no way of knowing when a new sale is made!
What ever form your using to log sales, could add a new record to this form with [blue]updated OrderNo[/blue] (do not use Order#). This would circumvent tracking. However, since I have no idea of your table structure, I can't say if this is a good thing to do. It'll work, but good . . . .
In any case, have a good look at the following before you continue with this:
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.