relationship & data update

B

balu

i have 4 tables (1) branches [many branches of an trade union] branch id is PK
(2) membership collection [member ship slip numberis
PK &branch id is look up field & forighn key
(3) development fuind collection [branch id is look up field & membership
field is forighn key]
(4) expences [pk is autonumber & branchid is lookup field]
kindly tell me what is wrong with the table desighn and relationship
and here development fund table membershipslip number as forighn key
causing second time entry ,may cause data duplication &if indexed work is
becoming tidious as the MEMBERSHIP AND DEVELOPMENT SLIP NUMBERS ISSUED FOR AN
WORKER IS DUPLICATING (A CHANCE OF MISTAKE MAKING)
AND QUERY ALSO not working well
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

third table relationship and query on form 3
auto lookup query over a form and save 0
Restoring Primary key - and more 2
Implementing a many-to-many relationship 4
update a field by inputting data in a different table 1
Entering data with many to many relationship 1
Combine data without the PK 6
Relationship problem - not showing data 2

Top