Creating Table from Multiple Tables

[spyder]

Ok, new to the forum and this product. Here is my dilemma and not sure where to post this.

#1- I have multiple tables based on UPC codes and product types. How can I create a single table out of those multiple tables and is that possible. Example, this is an inventory program that has different product types listed with serial number and company bar code numbers. Now I want a complete list of all tables for assignment to various employees????

#2- How can I add a hook or button to add another record from the detailed view? Each time I scan in a new item, I have to go all the way back to the table view to add a new record and with over 1400 units, that is very time consuming.

#3- Is there a way to create nested tables as well?????

Any help would be greatly appreciated.

[csr21]

#2- How can I add a hook or button to add another record from the detailed view? Each time I scan in a new item, I have to go all the way back to the table view to add a new record and with over 1400 units, that is very time consuming.

Hey, you don't need to go all the way back to the table view everytime, you can simply change the data in detail view and click on "Save as copy". Clicking on this button will insert a new record in the table. Clicking "Save" button will execute "update" in the table.

#3- Is there a way to create nested tables as well?????

I think you are talking about tables with foreign key links.. yes it is possible in Appgini

#1- I have multiple tables based on UPC codes and product types. How can I create a single table out of those multiple tables and is that possible

I think you can create such table or view in database.

[TheCodeRed]

in regards to building a table from multiple other tables, I do this as a report function. I have a Button/Link created to trigger the clearing and recreation of a table based on a bunch of calculations from random different tables. You can run this function at the Table_Init() hook if you want the table to be live data every time you access it. I put mine in the form of a button so it can only get run when the Admin clicks the button. (About once a month)

I already created the table and fields in AppGini and just uploaded it without any data. I could have just built a table outside of AppGini but I like the Printing and Export to CSV options that the Table View offers automatically. My customer really appreciates those functions. So it is nice to put all of the data into an AppGini designed table. Again, this also gives you the ability to control member access to the table.

THE FUNCTION:
Is really just a series of queries in a bunch of while loops and switches.
The query all of the data I need (sometimes in specific order if the query requires returned data from a previous query) and gather all of the data needed to do whatever calculations are needed to be done. Then use INSERT statement, once you have all of the data needed to create a record, at the end of your WHILE loop to create that new record.
If you need any help with this part, please ask.

[Emilly]

Hi I am noob to database and coding. I found Appgini very easy. Now I wanna create one table or a button from a multiple tables. Please help me how to make that function.