Is Portal Tool the right tool for the job?
I have a Client, Invoice, LineItem and Products table. Client and Product table are working perfect. The Invoice table is about 75% working. I have my Invoice pulling info from Client for Name and address via calculation field. I don't know if its right, but it seems to work.
What I'm *trying* to do is have a drop down menu so I can click on the product (From Client table) and have it added to the Invoice. Is this possible via the Portal Tool? I want my Invoice to be functional, not just a display tool.
Any advice? I'm willing to email my project file over to anyone willing to help.
Thanks a bunch!!