Parent-child relations

[Dida]

Hi,



I'm creating a database and I'm having trouble with my relations. It won't let me choose which is the parent or child table. My objective is to have access from a field in the back-end, to another table.


If you need more details, please let me know.

Your help is greatly appreciated.

Thank you.
Dida

[ranman256]

do you mean in the DATABASE TOOLS, RELATIONSHIPS?
or
in a form, with parent form / sub form?

if form, create 2 forms, edit 1 (the master) in this drag and drop a subform control onto the form (this will be the child)

[Dida]

In the database tools, relationships. Where we drag from one field to another to connect the two.

[rpeare]

Typically the MANY side of a relationship is the 'child' side
The ONE side of a one to many relationship is the 'parent' side

You just need to define what type of relationship (one to many, many to many, one to one) your tables have.

[Dida]

It only allows me to have one to many relationships for some reason.

[rpeare]

if you double click the line connecting the two tables you should be able to define the relationship type, or modify it.

You do not need to use the relationships at all if you don't want to they are there simply (from my point of view) to help create connections when you start building queries, so I haven't messed around with the 'how' of the join but I suspect it's examining your tables to see how your tables are indexed.

For instance if you have tblTest with two fields T1_PK and TestDesc, and have a second table tblTest2 with three fields, T2_PK, T1_PK, Test2Desc, the field T1_PK (the foreign key to tblTest) would have to be indexed (in the table design) as YES(No Duplicates) for a one to one relationship to be imposed.

[Dida]

I agree to not being obligated to create relationships until a query is built. However, for my case, I do need the relation because I'm trying to get data from another table that is associated with the first one.

Ex.
TblOne
tblOne_id
fieldOne
fieldTwo


TblTwo
tblTwo_id
fieldThree



I want fieldOne to be linked to tblTwo_id for the purpose of extracting and storing its related data to that record automatically from the back-end (datasheet view).

[JamesDeckert]

Looking at your tables assuming that the id fields are your Primary Keys, you would define them as you stated as one to many which you said earlier is all Access will let you do. What kind of relationship do you want?
each value in tblTwo_id can only occur once, but this value can occur many times in fieldOne of TblOne. This is one to many.

[Dida]

The one to many is fine. The main thing I want to be able to do is to get access through the datasheet view to other tables. Here's an example. I want it to be the same for another table.