A Data Entry form for a one to many relationship

S

sshelton

Hi,

I am trying to setup two forms in a database to enter information in a one to
many relationship. I have two tables:

1st table is: Lesson_number
Passage
Topic

2nd table is: Eposition number
Book
Chapter
Verse. (Text field which will have rich text in it)
Exposition (Text field which will have rich text in it)

I want to be able to enter lesson number and the info in the table and then
have a button where I click and another form opens up with the data for table
2. I wnat Exposition number to prefill with lesson number and for as many
times as I would use the form at that time.

Is there a way to do this?

You help would be greatly appreciated.

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
Add additional information to excel form after original data entry 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Excel does not accept text format! 0
Unable to display values in 2nd list box from 1st list box selection 2
Entering data with many to many relationship 1
Data entry for a table from a form 2

Top