Search results

ARGH! Still trying to figure it out....On the drinks table, the subdata sheet has the ingreident id's, but not the names theirselves.... I'm trying to create that table you said, cant find anything anywhere about a foreign key table. So I just make the drink the primary key. No luck getting...

You make it sound so easy! hehe. I'll give it a try and let ya know....

Ok, I have a database with 11,000 mixed drinks & their ingreidents. One table has the drinks listed, 11000 of them, and another table has the ingreidents, 1400 of those. When I click on the plus sign on the drinks table, it opens a smaller window, like a sub database, and the fields there just...

I got it to display all the ingreidents, however, there is a new record for each one. Example...one of the drinks are called ACID, and there are 4 records now for that one drinks, each with a different ingriedient. That gave a crazy amount of records! I need all the ingredeents together....

well, not really, this subform has got me pulling out what's left of my hair!

Ok, I have a database with 11,000 mixed drinks & their ingreidents. One table has the drinks listed, 11000 of them, and another table has the ingreidents, 1400 of those. When I click on the plus sign on the drinks table, it opens a smaller window, like a sub database, and the fields there just...