Need a form that access 3 tables

[Navik]

Hi,

I'm new to access and am creating a database for personal use.
Three tables: Publication, Story, Submissions. Publication table is a listing of magazines and magazine specific information. I've created a form for this table.
Story table is a list of stories and story specific information. I've created a form for this table.
Submissions table is made up of the auto-generated unique key from Publications and Story as well as submission-specific information. This is where I'm having issues.

I'd like a form for the submission table that uses drop down boxes to select the publication and title. I don't really need/want a subform with multiple records. I just want to be able to enter in one submission entry.

My problem comes into play where I can't make the story or publication selection populate the publication ID or story ID fields on the submission table. (I'd also like these selections to load values into disabled text fields for informational purposes.)

I also don't know VB (though have programed in RPG for 7 years).

I'd appreciate any help.
Thanks,
Navik

 

[gusbrunston]

[tt]
Hi:

I think that I would start by designing a query that drew the pertinent information from the three tables, and then build your form using the query for the data source.

Table1 |
Table2 |--- Query1 ........ Form1
Table3 |

HTH,

Gus

[tt]
Gus Brunston - Access2000/2002(DAO)[/tt]

 

[Navik]

Gus,

Thanks for the response.

I gave that a try, but didn't have any luck.

The tables look like this

Tbl:Story Tbl:Submission Tblublication
Stry_ID *1-many* Sub_Stry_ID
Sub_Pub_ID *many-1* Pub_ID

I'd like the form to have all the Submissions fields (except for the two ID fields) as inputable. To get an entry into the ID fields, I'd like to require a selection from a Story drop down box and a Publication drop down box. If this is doable through Query, then I'm doing something wrong (which very well could be the case).