Automatically fill in value from another table

[Hannu]

I have two tables in the same database. each table has a field called ID which is also the primary key. one table is person's private details and the other business details, they are linked together with a relationship.
I want to automatically fill in the business details table ID when I enter data into the private details table, ID field.
This assist me in looking at the Form which display fields from both tables. So when I fill in the ID field in the private table (or that part of the Form) the ID filed in the business details will automatically fill in.



Thanks for looking into this

[June7]

What is the relationship of these tables? one-to-one or one-to-many or many-to-many? Answer these questions:

Can person have many business?

Can business have many persons?

Will every person have a business?

If you want a business record to automatically have the ID of the person record, the ID field in business must be a number (not Autonumber) field. Assuming you do have relationship set in Relationship builder:

1. if you do entry in tables, open persons table, click on the + sign at left of record, enter record into business table. The ID will automatically populate

2. if you do entry in forms, use form/subform arrangement

If these tables are a one-to-one relationship, could be one table.

[Hannu]

What is the relationship of these tables? one-to-one or one-to-many or many-to-many? Answer these questions: relationship is one-to-one

Can person have many business? Good point but not in this case

Can business have many persons? not in this case. each person has a separate business information, this is like an address book where each person has business contact details, so it does not matter if there is another person in the same business.

Will every person have a business? no

If you want a business record to automatically have the ID of the person record, the ID field in business must be a number (not Autonumber) field. Assuming you do have relationship set in Relationship builder:I use a number for the person's ID, not autonumber.

1. if you do entry in tables, open persons table, click on the + sign at left of record, enter record into business table. The ID will automatically populate. good, this gets me a step towards the solution.

2. if you do entry in forms, use form/subform arrangement. Yes, I use a form to enter details and the aim is to populate the ID of business table when personal table is completed.

If these tables are a one-to-one relationship, could be one table.

Thanks for the help June7, so how do i populate the business ID when filling personal ID details using a Form?
I should tell you that this is an activity for my students so although it should reflect real workplace system it does not have to be perfect. the main objective is to learn to make simple tables, Forms, relationships and Reports.

[June7]

Use form/subform arrangement. Set the Master/Child link properties of the subform container control to synchronize the related records and automatically populate the business ID field when a value is entered in any other field of business record.

This is basic Access functionality and Access Help has guidelines on building tables, queries, forms, reports. What kind of class would you teach and not be familiar with these basics? I am sure there are many elementary tutorials available on the web and in reference books.

[Hannu]

Thank you for your help June7, I'll work on that advise, I have set the forms as form/subform, just needed the auto-populate function to "decorate" the database. What comes to the basic level, this course is VERY basic, students are required to operate a database and create simple tables etc, the students have never used Access before and have 2 day introduction. What comes to you suggestion of my skills and knowledge, unfortunately Access has never been my favourite software, hence lack of skills and knowledge so I rely of experts as yourself which I greatly appreciate, my expertise is elsewhere. What is "basic" to one person may not be so basic to another. My skills, although "light" are enough.
Thank you again for your help.