Im trying to populate through odbc certain fields on the form, [ex. patient_id, firstname, last name, address, etc] which must change when primary/unique field [hence patient_id] is updated. Relationship is dictated by default from db and is picked up by msquery as well. However i cannot find a way to create relationship of all fields to each other and aspecially primary key. Please advise me of how such can be assembled. I need for the form only to grab database fields, and based on primary key fill out portion of the form. [no need to overwrite/write to db] Thanks, your help would be greatly appreciated!!!