Cloning of records based on Criteria.

[Rudrabhadra]

Dear All,


I am a trying to learn access. I am trying to make a database which will help me in my job.
Appreciate if someone could help me on where I am stuck up.

1. The Ref_No./ Ref_type / PID_Inst_Type & Installation_Typ combo boxes shall also have a null value so that the subform will show all the records pertaining to the selections on the combo boxes.

2. Based on the selection of combo boxes, the selected/all records in the subform shall be duplicated (Btn_Duplicate_Click()) with the value in Nref_No instead of Ref_No (for the duplicated records)

The sample file is attached for reference.

Thanks in advance...

[mike60smart]

Hi

What are the 3 tables supposed to represent?

You have not set Referential Integrity between related tables.

Each Table should have an Autonumber PK to identify each Unique Record.

Any related tables should have a FK to link to the Parent PK.

Can you explain what you are trying to use the database for?

[Welshgasman]

Seems very similar to this thread?
https://www.accessforums.net/showthread.php?t=89105

so possible solutions there?

[Rudrabhadra]

Thanks for your reply and the guidance on the shortfalls. I understand that I have to refresh my basics once again. I shall come back to the forum after rectifying the mentioned points.