B
Black Knight
This is a follow on from my earlier post 'Best way ....?'
The database was set up by somebody else and I'm trying to streamline it
with my limited knowledge.
There's a table called DCS Data with lots of fields.
Two of them I've described below.
There's a field called 'MASTERLOOP'
It's not unique
There's another field called 'LOOPTAG'
This is unique
The way the data is recorded is as follows (example only) ........ you will
see how the two fields are related
MASTERLOOP | LOOP TAG |
12-X-123 12-XA-123
12-X-123 12-XB-123
12-X-123 12-XC-123
19-P-345 19-PA-123
19-P-345 19-PB-123
99-T-789 99-TA-789
99-T-789 99-TB-789
99-T-789 99-TC-789
and so on .....
So what I'm saying is that there are duplicate records on the MASTERLOOP
field.
The 'MASTERLOOP' field is used by other tables - I'm unsure why yet - Its
not been set up by me.
I think it might be best to have the MASTERLOOP field in a table of its own
so as not to have duplicates in the DCS Data table.
How do I set up my tables and forms so that when I enter a new record in the
DCS Data table, it puts a new record in the MASTERLOOP field in another
related table.
Sorry if I'm not clear in describing what I want to do.
Thanks for reading.
The database was set up by somebody else and I'm trying to streamline it
with my limited knowledge.
There's a table called DCS Data with lots of fields.
Two of them I've described below.
There's a field called 'MASTERLOOP'
It's not unique
There's another field called 'LOOPTAG'
This is unique
The way the data is recorded is as follows (example only) ........ you will
see how the two fields are related
MASTERLOOP | LOOP TAG |
12-X-123 12-XA-123
12-X-123 12-XB-123
12-X-123 12-XC-123
19-P-345 19-PA-123
19-P-345 19-PB-123
99-T-789 99-TA-789
99-T-789 99-TB-789
99-T-789 99-TC-789
and so on .....
So what I'm saying is that there are duplicate records on the MASTERLOOP
field.
The 'MASTERLOOP' field is used by other tables - I'm unsure why yet - Its
not been set up by me.
I think it might be best to have the MASTERLOOP field in a table of its own
so as not to have duplicates in the DCS Data table.
How do I set up my tables and forms so that when I enter a new record in the
DCS Data table, it puts a new record in the MASTERLOOP field in another
related table.
Sorry if I'm not clear in describing what I want to do.
Thanks for reading.