Generating Schemas from one parent table and 2 child table
I am trying to generate schemas using ADD generated items wizard. I
need a query to generate a schema which contains one parent and 2
child from 3 different table. They have PK and GK relation between
them. I tried writing query using joins and was not successfull.
.
Relevant Pages
- Re: Query vs form with child & parent: Deleting rows
... subordinate to that record, that is, all individuals (and sometimes child ... companies) whose Owner field contains the record key of the parent company. ... That second form is fed by this query: ... But I have a child table called "Channel"; ...
(microsoft.public.access.forms) - Re: Queries involving subforms
... If you create your query, with the parent & child tables joined, and add the ... you will get as many as there are child rows ...
(microsoft.public.access.queries) - Query vs form with child & parent: Deleting rows
... When I delete a row from a query involving both parent and child rows, ... when I display this query in a form and delete a row from there, ...
(microsoft.public.access.forms) - RE: Generating Schemas from one parent table and 2 child table
... your query here or elaborate more on what you are trying to accomplish? ... Thiago Almeida ... table with 2 child table. ... at-identity to copy the parent id to the child/children. ...
(microsoft.public.biztalk.general) - Re: list box from query
... If this helps, I have three nested forms (say, the parent, ... and grandchild) The listbox is in the grandchild ... and is based on a value in the child form. ... me to enter the query value. ...
(microsoft.public.access.formscoding) |
|
