portal

[geethanandh]

hello
I have three tables say A,B,C.
Table A has fields
Emp_no, Emp_name
Table B has fields
Emp_no,invoice_no,Emp_name(via portal)
Table C has fields
Invoice-no,Invoice_details

Table A and B has a portal relation,
Table B and C has portal relation but there is no portal relation between A and C.

Now i want to access the Emp_name of Table A from Table C.
Please help me to solve tis problem

Bye
Geethanandh

 

[ImStevenB]

One way would be to add the field Emp_no to table C.

I understand that table C is your Invoice table and the invoice number is the primary field - but if you store the Emp_no in Table C it is the fastest link to Table A.

HTH Im Steven B

http://www.myarcadia.net

 

[geethanandh]

hello Steven
Thanks,But i dont have Emp_no in Table C. I know that it would be easy by that way , i am looking for an alternate.

bye
geethanandh

 

[ImStevenB]

If you go through table B you might be able to look at it - but it's the long way around.

You would need to view the information in table B from table C. If you have a list of the invoices in table C you can click on the invoice number and have that open the related information in table B.

Like I said a longer way around but you could look at it that way.

HTH Im Steven B

http://www.myarcadia.net