how do you make a autocomplete form with a editable subform underneath

[cappuccino]

thanks but i am slightly confused

where do i change recordsource and stuff
and what is a compiund primary key, i heard of primary key

thanks again!

[June7]

My suggestions concern basic Access functionality. How did you create the forms and not know what RecordSource property is?

Change the RecordSource property of the subform. Open the subform in design view, find the RecordSource property on the property dialog.

A compound primary key is when two or more fields are used to define a unique identifier. In the case of tbl_loan, this will prevent a duplication of barcode and person pair. Will have to deselect BarcodeID field as primary key then select both BarcodeID and PersonID fields simultaneously and assign as primary key. I tried leaving just BarcodeID as solo primary key but the form would not work. Or don't have any field designated as primary key in tbl_loan and just set the BarcodeID field as Indexed Yes(No duplicates). But this setting or solo PK designation means can't have records that show the book was loaned to more than one person, meaning can't have history. Record would have to be deleted from tbl_loan when the book is returned before could be checked out to someone else.

Did you look at the Lending Library template?

[cappuccino]

do you mean foreign key?

and where can i find the lending library template?

thanks

[June7]

BarcodeID and PersonID fields in tbl_loan are foreign keys but the BarcodeID field was also set as a primary key. When I stated 'primary key' that is what I meant.

I also just noticed that the PersonID field is set as Index Yes(No duplicates), this needs to be Index Yes(Duplicates OK).

tbl_loan really doesn't need any primary key unless you want the compound key so as to prevent duplicate BarcodeID and PersonID pairs.

Open Access to create a new project. There is a Library Catalog template under Personal. Turns out that is not the same db as Lending Library which is available at http://office.microsoft.com/en-us/te...010206883.aspx