Active only Editing

[Dalagrath]

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.

[pkstormy]

I'm confused. Your form is set to Data Entry = True which means you should only see new records entered. Your Outcome (When I tried, I either got the OrderID to show multiples of a single number or numbers that had previous transactions recorded only) is confusing.

[Dalagrath]

I was able to get my friend to help me with this issue, thank you for your concern however.