Windows XP 
Access 2007
Hello all,
I am looking for help guidance to my issue here, I thought I approached this issue the right way, but my results are not as wanted.
Please refer to my sample database which I have stripped down with only 3 records left which should show what I am trying to do.
Daily,I would download from a website a number of .dat files which I rename to .txt files to import into this database which is working fine.
When you open the database it will display the main Station log page. The main form as you can see have 3 subforms with callsign history, stationlog and recording log. The main form and callsign history is what is imported from the website daily and are linked together via the facility id field, these two tables are not updated by me.
As you can see the station log subform is linked to the Callsign hist ID, so as the station changes call sign and I hear it, I wish to log that callsign via the station log, but it is not working correctly, I have to type in the correct callsign hit id and call sign. I really want to see all loggings for the many different callsign at opening of the form and the same goes for the recording, see all the different recordings for the many different callsigns. If I have loggings of different call changes, the only way to see the other loggings at this time is click on the different rows within the callsign history subform, this is not what I want.
What I want too see is if I search on the callsign on the main form, I want to see any loggings and recordings of that entry once retreived. I realize I can use the FacilityID on the main form to tie this to the subforms stationlog and recordings as well, is this my only option to make this work right?
Can I get help on this or tell me what I want can be done of do I need to change how I have the subforms tied together?
I hope this makes sense!!
Thanks
Reply With Quote
