I have for example 2 tables:
- used(us_id, code_id);
- codes(code_id, amount)
I want something like this:
If for example I have 5 eggs, and egg code is 1, then if the used table have reached 5 of ID 1 then in a from, the egg won't show up as choseable. (listbox, which get it's source from codes table)
I'm using Mysql server and Access connected by odbc.