Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-17-2019, 04:42 PM   #1
EllieCan
Newly Registered User
 
Join Date: May 2019
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
EllieCan is on a distinguished road
data entry with joining table

I am very new to Access, and learning a lot on the way. I have googled for hours to find a solution to this and am obviously not asking the question the right way.

I'm creating a database for client services which involves a many to many relationship.

While clients are registered individually, the visits are recorded on a family basis.

I've created a junction table that links clients to families, and families to visits (i've attached an image of the relationships below).

I understand how to make this work when there are records in both tables, but for new clients there won't be records in the Visits table.

What I think will work is if i create a registrations form that includes a Family ID number (that can be used later in the junction table), but which is not linked to the junction table, then i create a Visits form that also creates the input for the junction table (using a look up, i presume, to get the family info from the registrations form). Does that make sense?

How would I do that in practical terms?
Attached Images
File Type: png Screenshot (14).png (88.2 KB, 6 views)

EllieCan is offline   Reply With Quote
Old 05-17-2019, 04:52 PM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 2,094
Thanks: 25
Thanked 543 Times in 531 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: data entry with joining table

Hi. Welcome to the forum. Sounds like you could use a Household table to tie all family members to one record. Either that or add a designation for the head of family and tie all family members to it.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 05-17-2019, 05:59 PM   #3
EllieCan
Newly Registered User
 
Join Date: May 2019
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
EllieCan is on a distinguished road
Re: data entry with joining table

Quote:
Originally Posted by theDBguy View Post
Hi. Welcome to the forum. Sounds like you could use a Household table to tie all family members to one record. Either that or add a designation for the head of family and tie all family members to it.
So, if i understand you right, this would mean I donít need a joining table?

(omg, this idea makes me so happy!)

EllieCan is offline   Reply With Quote
Old 05-17-2019, 06:07 PM   #4
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 2,094
Thanks: 25
Thanked 543 Times in 531 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: data entry with joining table

Quote:
Originally Posted by EllieCan View Post
So, if i understand you right, this would mean I donít need a joining table?

(omg, this idea makes me so happy!)
Yes, sort of. So, in your members table, you would add a new field to designate the family group (whether you use a separate household table or just use the ID of the head of the household). Then, in your visits table, you would log this value (family group ID) instead of the ID of the person visiting. I hope I understood your request correctly.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Data entry - adding two new entry rows to a table via a form? peskywinnets General 1 01-16-2017 06:38 AM
Joining unrelated data in one table Ayshan Queries 7 12-26-2014 10:24 AM
New entry in a table using data from another table in a form akesy Forms 3 01-18-2013 02:11 PM
Updating Table data with data from preceeding entry?? saebodybuilder General 4 01-06-2013 09:16 PM
Data Entry to Table saip15 General 3 06-25-2009 02:57 PM




All times are GMT -8. The time now is 05:38 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World