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.

 

[MajP]

look in the help under subforms and then look at the northwind db that ships with office.

 

[Eggers]

That didn't help me much :/

 

[PHV]

for my A levels
???

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886