hi,
i would like the form that is titled "machine#search". to also be able to display all the faults by that machine number.
if you look at the form i just need some code to copy the machine number, into the subform. so if i search for machine 2, all the faults for machine 2 will be displayed in the sub form.
hope someone can make sense of this!
a little rusty when it comes to access!
thanks
hello...
I need a little help in making a small database, I have made the tables already but the hard part is the relation
LINK: www.sunalpina.com/test.mdb
well the thing is that I need to make a database for tables "Product", "Category", "Admin", well the problem is between the tables "Product", "Category".
I want to make a category example "food" and in that category I want to make a sub-category "italian", "japanese"
and in the category "italian", I place product "pizza"
and in the category "japanese", I place product "noodles"
I don't know how to place the sub-category relationship in the database...
could someone please help....