Recent content by erislover

[smack] That was it exactly. Grrr...

This is a different topic than the other "from based on a query" problem. Here is the skeleton of the database: tblInstruments one to many with tblLink many to one with tblCustomers So the link table has two primary keys (and only two fields, for that matter) which is allowing me to assign...

Oh, join key not found.... no, we are having different problems of the same type.

I am having the EXACT same problem. Let me guess, you have a many-to-many relationship set up with a "link" table inbetween the other two (where each table forms a many to one relationship here)? Well, even if not, that's my problem. And what is killing me is that the underlying queries are...

I appreciate the offer for help very much, but in the two days that this board has been down I went in and taught myself some VB! For reference, here's how I handled the situation. Private Sub ViewInstForm_Click() 'Handle button click by 'checking "instrument type" and then 'opening the correct...

It is definitely the latter, but unfortunately i don't know how to use VB at all.

Ok, I am finally to the point where I know exactly what I need and I hope it can be done. I will have a form that will need a button on it. The button will open another modal dialog form. BUT... which form it actually opens will need to depend on a record in the form that the actual control...

I need to create a database with information on different instruments. Each instrument will have some common information as one table, logically enough, with information like owner, user, company, et cetera. However, instruments will also have specific information that apply only to their...