Search results

You need to put the LoanID there. The borrower can be retrieved through a join between the loan table with the borrowers table then.

Hi, I have a form on which I have about 6 combo-boxes and a set of 3 radio buttons. I'm to the point that all the querys that fill these combo-boxes are in place. What I want now is a search button that updates a datagrid under it when clicked. The query in this datagrid needs to be...

right, How do I set a foreign key in access? I can only see Primary key. thanks for the advice

thanks for the advice. I renamed my ID's. Im still strugling with that one - to - one relation. Ive got a Material table now wich looks like this: Material Mat_ID Mat_Supplier Mat_PurchaseDate ... Mat_DetailID that Detail ID should then be the 1 to 1 with the idea in the machine or tank...

Hi, I want to make an access database but Im struggling with the relations a bit. I understand the one-to-many and many-to-many concept but seems like there is more then that I want to make a database that keeps track of things we lend. I have several items with different properties we lend...