Auto Populate fields

[blue310]

Hi

I am need of some help with my database design. I am no expert to Access/VBA by any means.

I have a form (see attached) which has a field called PropertyID. Originally I had Indexed set to yes(duplicates OK). When I would enter an ID the manufacturer, model, and serial # fields would auto populate. I then realized that with that setting users can enter duplicate data. When I changed Indexed to Yes(No Duplicates) I lost the auto populate function.

I would like to have the best of both worlds. I need the field to stay Unique as well as populate those 3 fields.

Thank you for your help.
[imgnothumb]http://bytes.com/attachments/attachment/6177d1330968134/relationships.j pg[/imgnothumb]
[imgnothumb]http://bytes.com/attachments/attachment/6178d1330968134/formdetail.jpg[/imgnothumb]

[Mihail]

I think there are 3 ways to do that:

1) Create a separate query and set it as record source for your form;
2) Edit the record source for your form then change in this place the query.
3) Define for each table a form and use this as sub-form in their parent form.