Home -> Usenet -> c.d.o.tools -> Forms Help

Forms Help

From: Shelli D. Orton <shelli.orton_at_crha-health.ab.ca>
Date: Thu, 08 Jul 1999 20:40:24 GMT
Message-ID: <37850D24.17924808_at_crha-health.ab.ca> 





Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



I have three tables similar to the ones below.  A person from table one
can be associated with table a business unit from table three in one or
more roles (eg. manager).  These relationships are defined in table two.


Table One        Table Two                Table Three

PersID            BusinessUnitID        BusinessUnitID
Name              PersID                    BusinessUnitDescription
Address           PersRole




Phone



I would like to create a form that allows the user to view and update
these relationships.  The catch is I would like it to be tabular.  See
example below.


Business Unit        Description                Person             Role

A1234                     Health Services           John Smith
Manager
A1234                     Health Services           Jane Doe
Corporate Support
B3389                     Pediatrics                    Bill
Jones           Manager
B3389                     Pediatrics                    Jane
Doe           Corporate Support





The only way I've been able to display this is by creating view.
However, since the view is based on more than one table I can not update
from it.  Ideally I would like the user to be able pick the business
unit and person from LOVs based on their respective tables.



Any suggestions??  Can this even be done or am I stuck with displaying
one record at a time?



Thanks for any help,


Shelli


--------------C74355B1B3BDD4876EB16FD4
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit





<!doctype html public "-//w3c//dtd html 4.0 transitional//en">


<html>




I have three tables similar to the ones below.&nbsp; A person from table
one can be associated with table a business unit from table three in one
or more roles (eg. manager).&nbsp; These relationships are defined in table
two.


<p><b>Table One&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Table Two&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


Table Three</b>


<p>PersID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


BusinessUnitID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BusinessUnitID


<br>Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


PersID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
BusinessUnitDescription


<br>Address&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


PersRole


<br>Phone


<p>I would like to create a form that allows the user to view and update


these relationships.&nbsp; The catch is I would like it to be tabular.&nbsp;
See example below.


<p><b>Business Unit&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Description&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


Person&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Role</b>


<p>A1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


Health Services&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
John Smith&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Manager


<br>A1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


Health Services&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Jane Doe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Corporate
Support


<br>B3389&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


Pediatrics&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Bill Jones&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Manager


<br>B3389&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


Pediatrics&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Jane Doe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Corporate
Support


<p>The only way I've been able to display this is by creating view.&nbsp;


However, since the view is based on more than one table I can not update
from it.&nbsp; Ideally I would like the user to be able pick the business
unit and person from LOVs based on their respective tables.


<p>Any suggestions??&nbsp; Can this even be done or am I stuck with displaying


one record at a time?


<p>Thanks for any help,


<br>Shelli</html>





--------------C74355B1B3BDD4876EB16FD4--

Received on Thu Jul 08 1999 - 22:40:24 CEST












Original text of this message