473,385 Members | 1,720 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Upon click, populating table from a table in 1-1 relationship in Access

Have a table with my master information for individuals and would like to automatically export the data to other tables based on the criteria selected. On my master table you can select multiple yes/no fields; when yes is selected I would like the majority of the record to be exported to a second table. (i.e. while entering information, if "Child" is clicked, this information will be populated in the Children table.) I'm not sure how to go about doing this.
Also, when a selection is made, there is more specific information I would like to gather just specifically for the members of that category (i.e. for children I want to enter what grade they're in). Is there some way to create a sub-table that appears when the information is initially being completed? I am able to go in an manually do these things but I'm wondering if there's a way for Access to do it for me.
Note: the information is to be input by members of the public so I want to keep the process as simple as possible by providing one form with all the fields that need to be filled out.
Thanks!
Jan 2 '13 #1
2 1580
zmbd
5,501 Expert Mod 4TB
Oh wow.... it really sounds like you need to read the following:

A Tutorial for Access

Database Normalization and Table Structures.

After that, we can start to design a form that can handle the data input.
Jan 2 '13 #2
NeoPa
32,556 Expert Mod 16PB
I'm very much with Z on this, but I would say the table layout needs serious reconsideration too. I definitely recommend you check out those linked articles.
Jan 3 '13 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Doron | last post by:
is there a setting that will ebnable uniform extent allocation upon creation of index/table by default ? if there isn't any default setting can you code it in? thanks, Doron
6
by: vad | last post by:
Hi! I am new to asp and here is my question. I have an MS Access datacase,In one table I stored all the information regarding one truck, including 4 images for each of the truck.The data type...
2
by: Fred | last post by:
Hi. How do I import while mapping an excel table to an access table please??? I've searched around and all I can find is a software product or code that does the same thing as the access...
2
by: jeff regoord | last post by:
Is it possible to change the table structure in Access once the table has data in it and how would one attempt this if so?
1
by: kezhou wang | last post by:
Could you please tell me how to create a fake MOUSE CLICK in a Table ?
34
by: MLH | last post by:
http://www.opm.gov/Fedhol/ http://www.opm.gov/Fedhol/2008.asp Federal law (5 U.S.C. 6103) establishes the following public holidays for Federal employees. Please note that most Federal employees...
7
by: nmsreddi | last post by:
Hello friends I am using Access2003 for the first time ,my problem is how to find the all existing table names in access database. some thing like we use sp_help in sql server for getting...
4
by: jaishu | last post by:
Hi all, I am in the process of developing a small Access application. i have the table locally in Access and I am using the following code to get the recordcount ( or to check if any record...
1
by: franc sutherland | last post by:
Hello, I have a client who uses Access 97, but does not have the Linked Table Manager. The system is split into front and back end. Is it possible to install the Linked Table Manager into...
1
by: senort01 | last post by:
Is it possible to create a table within MS Access Reports so that horizontal data stays aligned? For example, I have two columns of data. The left column is fixed, the right column will be...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.