Creating forms with optional fields - help!

[Eggers]

I'm trying to make a database for my A levels and I've encountered a problem with a form.

I have a transactions table listing every transaction that takes place in the company. Some times certain things (like stock) will have a different Transaction ID assigned every time new stock of that type is ordered, so I have a Stock Transaction table to link the Transaction and Stock tables, containing just Stock ID and Transaction ID. I have several of these types of relationships and tables.

When making a form for the user interface for Transaction ID I thought I could just put each of the other IDs in the form and they'd remain blank when that particular ID isn't present, but show the data when it is. Instead, no data is present; or just putting Stock ID in shows only records with Stock ID present.

How could I get it to do as I initially hoped?

Thanks for any help.

 

[ashishprem]

You the SQL join query in Form recordsource property. Then assign the textboz property by selecting the appropriate column of the query from the property window.

 

[Eggers]

That didn't help me much, it just did the same thing; only showed records that had a stock ID AND a transaction ID

IGNORE THAT

It worked! Thank you so much! <3<3<3

 

[Eggers]

Well it did work... except now I can't seem to add new records from it. Agh