Populating a Field from a Lookup Table But Editable

[rdalopez]

Hello,

I hope you guys can be patient with me as I have just started with AppGini and a newbie on PHP.

Okay, to start off, I have three tables:

Invoices
---id
---InvoiceNumber
---Customerid (which is looked up on the Customers Table)
---DueDate

Services
---id
---Service
---UnitPrice

InvoiceDetails
---id
---InvoiceNumber (which is looked up from Invoices)
---Service (which is looked up from Services)
---Qty
---Unit_Price
---Amount

Here's my problem:
1. After selecting a Service from the Services table, I want the InvoiceDetails.Unit_Price to contain the Services.UnitPrice
2. However, the user may opt to change the value of the InvoiceDetails.Unit_Price
3. After changing the value of InvoiceDetails.Unit_Price, I want InvoiceDetails.Amount to contain InvoiceDetails.Unit_Price * InvoiceDetails.Qty

Actually, the problem is I don't know how to do it.

I would appreciate any help from you guys.

Thank you so much!

[Satya Kavala]

Hello ,
please check your PM.

[table_otto]

Whats the hell should this? He asked in a open support forum and you answers often only with this above... Why you dont tell all AppGini customers your hints?

[shasta59]

There is no need to be abusive in this forum.

Satya charges for his services and that is fine. No one has to retain him if they do not want to. I have had people contact me privately and have done work for some. I also do not post everything up which I code. I spend a fair bit of time, in some cases, making sure it works and is universal in application so I can reuse it. Nothing says I have to post the answer for everyone to use. In fact I have over 1600 lines of additional code I use to extend AppGini. The biggest one is my method for allowing any setting (just about) to be made from the admin section. I can set Mass Delete by individual table, set whether the detail view appears on a separate page or not. Plus about 30 other settings all listed by table. This has made my generated applications easy to administer by anyone. I am not sharing this code but may consider selling it. It is very useful and saves having to change php pages, save them and upload them again.

I am working on a method right now which I will not be posting. Allowing a member to be a member of more than one group. Not a simple thing to make sure it works right but I need it by the end of the month and I also think Ahmad is working on something similar for a future version.

If rdalopez does not like the answer or the price he does not have to retain anyone. If there is a real need then it may be the best solution depending upon urgency.

I only ask that everyone respect everyone else.