Thedm

I realize one of my main issues is that I have Cutomers-->Products-->>Custom Price then join that with Invoices.. vs Customer-->Invoices join with products... But i dont see another way to do custom prices..

I am creating an invoice database. It is a standard invoice solution with one minor glitch. Each customer CAN have a different price with each product. To solve this i created a join table between products and customers and put a portal on the customer page where the user can from a drop down change any price manually. That works fine. But now when I try to create a new invoice the invoice table doesn't insert the customer name-address etc. Here is what I have. I cant see the forest through the trees on this one... can anyone give a hint. thanks

Ok solved it... .I was/am mentally deficient. I needed to use GO TO RECORD... much simpler and works right. For some reason I had a blind spot on using that.

Ok, I have a portal issue. Objective: Portal layout I am using has space limitations so I want to be able to click a button and expand the picture in a portal out to a full screen view. When I use a script to open a new window (from inside portal)to enlarge a picture it goes to the 1st record every time and not the related record. I can then manually scroll through the records to the correct one... I have Table A: Primary Data Table ------------>Layout #1 Table B: Display Table with Portals.---->Layout #2 Enlarged view------------------------->Layout #3 My script is: Allow User Abort [Off] New Window [Name: "Enlarged Picture View";Style: Document] Go to Layout ["#3 Enlarged Layout" (Table A)] Pause/Resume Script [indefinitely] Close Window [Current Window] Layout "Enlarged vew" only has one container field in it from Table A. "::Picture" All items in Table B-->Layout 2 are inside the portal.. I have this running correctly on two other databases but cannot figure out why it keeps going to the first record on this one. Any insight would be grealy appreciated. Thanks

Hello, Can anyone point out what I am missing. Solution is a Contact Manager. I have a simple one table solution. I have a 100 Records. Some of the records are related and I simply need to be able to have a drop down listing all names. The user needs to be able to link as many names he wants by selcting them from a portal. I created a self join table using the primary key. I linked them (it gave me a 1-1 relationship but I dont see a way to make it one to many...) I then created a portal selecting records from the self joined table. Now, when I create a new record it enters the full name into the first row of the portal. I can go into the second portal row and access the drop down of all names, but it gives a not modifiable error. Any help would be appreciated. Thanks

Ok, Can anyone tell me if this is even possible? I have a fairly simple invoice solution... With one very troublesome issue. I have customer table, product and invoice table. I have an issue though that each product is base: Widgets, Gidgets, Gadgets, etc But on each and every widget I have a modification that I have to make: XL, engraved, Blue/Red, etc. along with notes for the invoice. But when I pull the records into the invoice in the portal and I allow modification in browse mode anything I type into one product automatically changes all like products. Ex: LINE #1: Widget: XL, Blue. Engraved. If I enter another Widget it automatically changes the previous entries on the invoice that share same product name/id. Is there anyway to not have it do this? Appreciate any insight, Thanks.