Search the Community
Showing results for tags 'relationships'.
Found 7 results
-
Best Practice in Linking tables through an application
Benades posted a question in Tables, Views and Relationships
Hi, I have an application that I am building for an engineering company that would consist of the main departments, namely: Sales, Manufacturing, Installations, and Finance. A key function of this application is traceability between departments. What would be the best practice in linking these department documentation together? Scenario 1: By creating a centralized table that contains the quote #, manufacturing #, installation #, invoice #, and status. Each department table updates the centralized table to keep track throughout the process. Scenario 2: Having one single table for all the mentioned departments. I foresee some problems with this solution. Scenario 3: Each department has its table referring to the previous department inside their department table and deploying by using views to combine the necessary data. Do you have any suggestions or comments on the different scenarios? Perhaps even guides pertaining directly to the problem at hand. -
Caspio has this feature, Display Value, nice when a joined table is being used as a lookup, with a key and a value. But how it works seems backwards. If I pick something from the dropdown, then I, as the administrator, see the lookup value, instead of the key, in tables. If I check “Use display value on DataPages,” then my users see the lookup value in DataPages. But often I, as the administrator, want to see the key while my users see the lookup value. Am I correct that Caspio cannot display the lookup value on users DataPages unless it does the same on Datasheets? Thanks,
-
I have two kinds of Budget items. table 1: Budget child table 1: Services child table 2: Check Requests When I report on Budget items, I want to see Services and Check Requests on separate rows in the same View, like this: budget# - service# - checkrequest# - amount 22 - 15 - NULL - $50 22 - NULL - 7 - $50 Budget1 Total=$100 Should I combine child tables 1 and 2? Or is there a way to join them to Budgets so that they can appear on separate rows, as in above?
-
Hello, I am developing a report result based in two tables: the first one is holding the 'clients' with unique IDs, and the other one have the 'products' also with their IDs. Both lists have details, however the clients have special columns which indicates the products they have. For example, the 'client 1' has 3 more columns because he has the product 1, 24 and 33. The clients may have up to 9 products each. The report should be generated by searching for the name of the client, listing his products. The thing is that I don't know how to generate this report, it just shows the 'product id' on the results, which should be replaced for the 'product name' instead. I thinks the best way to do it is a many to many relationship, because the clients can have more than one product each. I've read something about making another table which would link all the information as a many to many relationship, but I am not sure how I can list the results from an "empty" new table. Is there any other way to do it?
-
Hi all! How can I have multiple values pass as a single parameter in a detailed report datapage? Example: An asset has 3 serial numbers associated with it. I want any one of those serial numbers to pull up the assets profile when entered into a detailed report datapage. I hope this makes sense and I can get someone to shed some light on how to do this. I have looked at the tutorials for relationships, views, and one-to-many but still cannot get it to operate how I want it. Maybe I am just misunderstanding how it works. Thank you! Logan
-
Hi, I'm making an app and one of its main uses is booking time. Every Booking has Days, and every Day has Times, and every Time has Services. I planned on sending the autoID from each of these tables to the next by passing parameters, so that Services at the end of this chain will have the ID of the Booking, Days, and Times. My question is why should I JOIN these tables if I'm passing parameters? I can always create Views with joins for the purposes of the views. I think I'm missing something basic. Second question, if I should join, which referential integrity checks should I apply? thanks
-
Hi, I have a details page that I want people to be able to comment on. I've successfully added the comment to the layout, and I've tried to pass parameters. The parameters aren't working. How do I auto-associate a new comment with the topic or page that it's on? The form correctly records the comment and whatever the user enters, but the User ID and Product ID aren't coming through. thanks, M
