B
Black Knight
Please could someone help me out here.
I'm involved with a project at work and we're using Access 97 to store the
data.
I don't think the 'expert' who set it up really knows what he's doing
becuase we are manually copying the same data into to several tables etc
rather than having all this done through one or more forms and make it more
automatic.
Basically its just a table with various fields (yeah I know they're all like
that !)
I've loads of questions but firstly I need help with the main problem
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 for each MASTERLOOP reference there could be several records associated
with it.
How do I make a form that displays the one MASTERLOOP reference number but
also displays all the associated records in a sub form one at a time ?
Like this
Record 1
-------------------------------------------------
12-X-123
-------------------------------------------------
12-XA-123
-------------------------------------------------
Record 2
-------------------------------------------------
12-X-123
-------------------------------------------------
12-XB-123
-------------------------------------------------
Record 3
-------------------------------------------------
12-X-123
-------------------------------------------------
12-XC-123
-------------------------------------------------
Also how do I set a form up to enter a new MASTERLOOP reference number and
then allow me to add as many records as are associated with that one number
?
Sorry its long-winded - I was told Access will make it easy !!!
I'm involved with a project at work and we're using Access 97 to store the
data.
I don't think the 'expert' who set it up really knows what he's doing
becuase we are manually copying the same data into to several tables etc
rather than having all this done through one or more forms and make it more
automatic.
Basically its just a table with various fields (yeah I know they're all like
that !)
I've loads of questions but firstly I need help with the main problem
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 for each MASTERLOOP reference there could be several records associated
with it.
How do I make a form that displays the one MASTERLOOP reference number but
also displays all the associated records in a sub form one at a time ?
Like this
Record 1
-------------------------------------------------
12-X-123
-------------------------------------------------
12-XA-123
-------------------------------------------------
Record 2
-------------------------------------------------
12-X-123
-------------------------------------------------
12-XB-123
-------------------------------------------------
Record 3
-------------------------------------------------
12-X-123
-------------------------------------------------
12-XC-123
-------------------------------------------------
Also how do I set a form up to enter a new MASTERLOOP reference number and
then allow me to add as many records as are associated with that one number
?
Sorry its long-winded - I was told Access will make it easy !!!