Access Template generating multiple records

[shani908]

Hello .

I am trying to customer this template for my need. There is something that I need to fix and I cannot figure out how .

Every time I create a new "Public Notice List" Entry , it creates multiple records in "PubOwnerT" table .

Please advise solution and why is this happening.

Please check attachment for Template.

Thanks


Details of the functionality and relationship is as follows :

1) Data Entry starts from the form name "Public Notice List"
2) Click on "New Public Notice" to add new entry.
3) fill the form, Field "Owner Name" is a combo box, whenever I add and save an entry It generates multiple records.

Table are as follows :
1) "Companies" : One company can have many agents .
2) "Agents": One agent can be marketing many Properties .
3) "PubOwnerT" : One Owner can have many properties.
4) "Properties" : Details about each property and its Publication information.

[June7]

I am not able to open the template file. Provide your working file.

[shani908]

I am not able to open the template file. Provide your working file.

Its Accdt format. I am on access 2021.

Can you please explain how to export for Access 2010 ?

Thanks

[mike60smart]

Hi

It only creates 1 New Record when I create a new "Public Notice List" Entry and it also only adds 1 Record to the table "PubOwnerT"

Db attached in Accdb Format

[moke123]

Accdt is a template file. You need to save it as an accdb file.

[shani908]

okey just attached.

Accdt is a template file. You need to save it as an accdb file.

[shani908]

I just used the COntact_Management template. Create one record and it generated two entried in "PubOwnerT" table and a Singe entry in "Public Notices" Table. ):

[mike60smart]

The structure of your Property Details Form is wrong.

It should be bound to the 1 table named "Public Notices", not the 3 tables that you currently have

[June7]

I know it is accdt. I have used accdt before and no problems creating accdb. The error indicates issue is due to creation with later version of Access. Can't create accdb. Working version posted opens just fine.

I tried input to PublicNotices form and it fails with error "need record in Agent". There is no way to select an agent via form. Form RecordSource should not include Agents table. Similar to what mike60 advised about PropertyDetails, and I agree. Don't complicate RecordSource unless absolutely have to. Why is PubOwnerID field in query 7 times?

If you want to display related info from lookup tables, include fields as columns in combobox then expression in textbox can reference combobox column index, index begins with 0:
=cboAgent.Column(2)

[shani908]

I know it is accdt. I have used accdt before and no problems creating accdb. The error indicates issue is due to creation with later version of Access. Can't create accdb. Working version posted opens just fine.

I tried input to PublicNotices form and it fails with error "need record in Agent". There is no way to select an agent via form. Form RecordSource should not include Agents table. Similar to what mike60 advised about PropertyDetails, and I agree. Don't complicate RecordSource unless absolutely have to. Why is PubOwnerID field in query 7 times?

If you want to display related info from lookup tables, include fields as columns in combobox then expression in textbox can reference combobox column index, index begins with 0:
=cboAgent.Column(2)

Thanks . noted