Ok I'm posting my little problem here as I'm not sure which subforum it should be in, other than perhaps forms or query's. So dear mods please move this as necessary! I'm using outlook 2007.
I have a database I'm building for my wife. It currently has three tables. One is a list of supplies. Each with a price, a name/desc, a type, a price per unit, and unit size and of course a primary numeric key
The next table is a recipe table. It has a name, a memo field for the method and then the primary key id.
The third table is a list of supplies needed for the recipe: ingredients. It contains, it's own primary key of course, then a copy of the primary key for the recipe it belongs to, and a copy of the primary key for which supple it is along with an amount field and a cost field.
I've created a relationship between the three tables on Recipe ID and supplies.
Now I can create forms to add records and navigate them easily enough but the form I want for the Recipe table is complicated.
I want to create the Recipe and then add records to the ingredients table for it by selecting from a prefilled combo box.
I've populated the combo box from the supplies table with the name/desc field and the hidden primary key setting it to remember the value for use later.
But I'm having trouble getting the form to then call up the other information for this entry. I've created a button on the form which runs a query simply selecting everything from the supplies. For the name/desc field I've added a criteria using the builder, selecting the <value> option for the combo box control on my form. I was going to then try to display these values in a subform.
However, the button simply opens a blank query in table view. I've populated my tables with some dumby data, so I've no idea why this isn't working?
Any ideas? I don't think it can be a data validation problem as the combo is populated from the same field that the query is trying to match its value against.
I'm stumped..
I have a database I'm building for my wife. It currently has three tables. One is a list of supplies. Each with a price, a name/desc, a type, a price per unit, and unit size and of course a primary numeric key
The next table is a recipe table. It has a name, a memo field for the method and then the primary key id.
The third table is a list of supplies needed for the recipe: ingredients. It contains, it's own primary key of course, then a copy of the primary key for the recipe it belongs to, and a copy of the primary key for which supple it is along with an amount field and a cost field.
I've created a relationship between the three tables on Recipe ID and supplies.
Now I can create forms to add records and navigate them easily enough but the form I want for the Recipe table is complicated.
I want to create the Recipe and then add records to the ingredients table for it by selecting from a prefilled combo box.
I've populated the combo box from the supplies table with the name/desc field and the hidden primary key setting it to remember the value for use later.
But I'm having trouble getting the form to then call up the other information for this entry. I've created a button on the form which runs a query simply selecting everything from the supplies. For the name/desc field I've added a criteria using the builder, selecting the <value> option for the combo box control on my form. I was going to then try to display these values in a subform.
However, the button simply opens a blank query in table view. I've populated my tables with some dumby data, so I've no idea why this isn't working?
Any ideas? I don't think it can be a data validation problem as the combo is populated from the same field that the query is trying to match its value against.
I'm stumped..
