Hello there Access friends!
I am having slight trouble on forms and getting a single thing to work for me.
Right now this is my set up:
tblTransactionLog
TransactionID(PK), Action, OrderID(fk), Location(fk), Time
tblActions_MASTER
ActionID(PK), Action
tblLocation_MASTER
LocationID(PK), Location
tblOrders
OrderID(PK), Client Name(fk), Item(fk), Amount, Active(Y/N)
So there is my setup. now here comes the really tricky situation. I of course have lookup fields for the FK's and everything is set up relationship wise. But the issue comes when I go into Form Mode.
I have a form, which looks like this:
This form is a Data Entry type form.
Now I only want the Active (the ones marked yes/1/checked) orders in the tblOrders to show up on the OrderID part of the form. Then, I want Location to point towards the Location in tblLocation_MASTER and the Action Taken to point towards tblActions_MASTER.
My Outcome: When I tried, I either got the OrderID to show multiples of a single number or numbers that had previous transactions recorded only.