Forms Designing advise Please?? 1

[qajussi]

Hi!
This might be a too basic question.

I am trying to create forms with Parent's primary ID come up automatically in other forms??

Table 1
ParentID
LastName

Table 2
ChildID
ParentID
ChildAge

Table 3
SchoolID
ParentID
SchoolName

I am trying to create forms to do the data entry.
1) Should I create three different forms??
2) What would be a good designing standard?
3) I want the ParentID to come up automatically on each of other forms?? How can I do that??
If I was filling Form 1(into table 1), ParentID =33 and after that I am filling into Table 2 and Table 3 using form 2 & 3.
How can I ParentID 33 to come up in each of form2 and form 3?? So my users don't have to type in 33


I will be creating data entry forms ..I need very simple forms without redundancy of entering Parent's primary id??

Can you help??

 

[inzzane]

I'm fairly new myself, but might be able to help. It sounds as if you're not mentioning all the tables you have, or you'll probably need more.
If I'm Right, it'll look something like this:

Table 1
ParentID:Autokey
LastName:Text

Table 2
ChildID:Autokey
ParentID:Num
ChildAge:Num

Table 3
SchoolID:Autokey
ParentID:Num
SchoolID:Num

Table 4
SchoolID:Autokey
SchoolName:Text

Then make sure you use "Relationships" to link each of the identical ID's. This should allow you to never see the ID's unless you want to, as they'll automatically be created for you and hidden in the system.

Youll also still be able to add more columns to each of the tables if you want/need to later.

Hope this helps.

 

[inzzane]

Correction to Table 3:

Table 3
SchoolID:Autokey
ParentID:Num
ChildID:Num

 

[TheAceMan1]

How are ya qajussi . . . . .

Have a look at the following links. They are the [purple]Heart & Soul[/purple] of any database. So get to know them well . . .

[blue]Fundamentals of Relational Database Design[/blue]

http://www.alphabetcitydataworks.com/FundamentalsOfRelationalDatabaseDesign.doc

[blue]Normalizing Tables[/blue]

http://support.microsoft.com/default.aspx?scid=kb;en-us;209534&Product=acc2000

[blue]Table Relationships[/blue]

http://support.microsoft.com/default.aspx?scid=kb;en-us;304467&Product=acc2000

See Ya! . . . . . .

 

[qajussi]

Thanks for your input.

I am looking for the help with forms...to have ParentID to come up each of other forms????

I created the relatioship but parentID doesn't come up in other forms...

 

[qajussi]

Ok..
I think I misguided you.

I was asking about the form....
To get the PrimaryID of one table to come up in another table or form so that I don't have to fill in the primaryID ..

Anyone can help???

 

[TheAceMan1]

qajussi . . . .

No . . . no misunderstanding. Its just that the question you ask shows a lack of uderstanding relationships (not trying to sound demeaning here).

Anyway the [blue]easiest thing you can do[/blue] is to make Form1 (based on table1) a [blue]Main Form[/blue] and Forms 2&3 (based on tables 2&3 respectively) [blue]subForms[/blue] to the MainForm. [blue]Both linked by ParentID[/blue]. [purple]The ParentID's assigned in the mainform, will automatically post in the subforms.[/purple] This is per the tables in your post origination.

You should be able to do this with the [blue]Form Wizard![/blue]

See Ya! . . . . . .

 

[qajussi]

Hi TheAceMan!

Thank you so much for your help.
I didn't take it offended. I just thought I wasn't communicating clearly.

I think you are right about my knowledge of relationships.
I have been working with the database for a several years now.(tables and web pages)

I strugggle a little when I design tables and assign relationship.

I tried what you told me but it didn't show up(ParentID).

Table 1
ParentID
ParentName

Table 2
ChildID
ParentID
ChildName

Table 3
ContactID
ParentID
Address


I built the relationship between Table 1 & 2 and Table 1 & 3 with ParentID.

I created three several forms, form1, form2, and form3.

form1 is from Table 1 ...

From form1, I created a subform by using the existing form2.

The ParentID's value didn't come up automatically in form2.

What did I do wrong here??

Another question??
IF I create web page in the access, can what I am trying to do with the form be done with the web page??
Please help...

Thank you so much.

 

[TheAceMan1]

[blue]From form1, I created a subform by using the existing form2.

The ParentID's value didn't come up automatically in form2.

[purple]What did I do wrong here??[/purple][/blue]

Nothing I can think of . . . .

[purple]Is there data in table1?[/purple]

[blue]IF I create web page in the access, can what I am trying to do with the form be done with the web page??
Please help...[/blue]

I've never done web pages! . . . sorry . . .
This is another question you can post.

See Ya! . . . . . .