So I've been trying to build a database for here at work, in order to help us track our radio sets we have on hand. The problem I'm running into is that once I input all the information into the database, I need to use a form, to allow multiple users to select certain components of the radios, and display them on the form, without having access to the root tables. I was told to use a query for this, but I'm having issues trying to build the query.
The issue is this:
I have 3 tables built right now, tble radioset, tblertserial, and tbletruck.
the radio set consists of two rt(receiver transmitters) and one truck.
I've built the relationships, but that doesn't seem to be doing anything. When I attempt to build the form, I've got 2 records as of now. (I'm only using 2 until I can wrap my head around the basics, and then I'll actually create multiple records)
On the form, the first page will show the radio set number, and then should have a drop down box which should allow me to select 2 RTs, and another drop down box to select 1 truck.
On the second page, I need to be able to select 2 more RT's, and one more truck.
The two issues I'm having right now are this:
1. I can't figure out how to build the query to allow me to select multiple RT's per set number.
2. I can't figure out how to set the query up so that once I've selected either the RT's or the trucks, those options are no longer available for selection on future pages.
Right now, this is an example of what I'm getting on my form:
Set Number 12130001
RT Ser *dropdown box*
1234
2345
3456
4567
Truck Ser *dropdown box*
1234
2345
I can select one of the RT's, and one of the trucks, but when I go to the second page on the form, I have the exact same options. I need to dumb this down, so that once selected, the serial numbers are unavailable for future selection.
I was told not to use the lookup fields in the tables, and to use a query instead, but I can't figure this out-it's like greek to me. I'm sure you all get really tired of answering questions from idiots like me, but any help that any of you could give would be greatly appreciated!
Seth
The issue is this:
I have 3 tables built right now, tble radioset, tblertserial, and tbletruck.
the radio set consists of two rt(receiver transmitters) and one truck.
I've built the relationships, but that doesn't seem to be doing anything. When I attempt to build the form, I've got 2 records as of now. (I'm only using 2 until I can wrap my head around the basics, and then I'll actually create multiple records)
On the form, the first page will show the radio set number, and then should have a drop down box which should allow me to select 2 RTs, and another drop down box to select 1 truck.
On the second page, I need to be able to select 2 more RT's, and one more truck.
The two issues I'm having right now are this:
1. I can't figure out how to build the query to allow me to select multiple RT's per set number.
2. I can't figure out how to set the query up so that once I've selected either the RT's or the trucks, those options are no longer available for selection on future pages.
Right now, this is an example of what I'm getting on my form:
Set Number 12130001
RT Ser *dropdown box*
1234
2345
3456
4567
Truck Ser *dropdown box*
1234
2345
I can select one of the RT's, and one of the trucks, but when I go to the second page on the form, I have the exact same options. I need to dumb this down, so that once selected, the serial numbers are unavailable for future selection.
I was told not to use the lookup fields in the tables, and to use a query instead, but I can't figure this out-it's like greek to me. I'm sure you all get really tired of answering questions from idiots like me, but any help that any of you could give would be greatly appreciated!
Seth
