Maybe linked databses?
I'm making progress since me previous question, and found the free trial - thank you!
I see the data from my embedded tables in something like sub-databases? I'm not sure what they're called. But the data from each client is together. How do I get them to go back to the correct client and display on the different client row.
Thank you!
5 replies
-
Ninox creates databases. Each database contains tables. Tables contain rows and columns, similar to a spreadsheet.
When you enter a database, tables are listed on the left. Click on a table to display a list showing the rows and columns of that table. Click on any row in the list to view a form that contains fields for that row (fields show the contents of a column for the current record). Click the "Form" and "List" buttons above the list to toggle between list and form.
Click in the "Find" field above the list, enter your search criteria, and hit the enter key to perform a search based on data contained in any of the columns shown in the list. Click the "x" in the Find field, to restore the original found set. Welcome to the world of databases. Enjoy!
-
The sub-databases you refer to are probably "Views". Views allow you to see data from another table on a form. Think of a view as being a portal to another table. For more information on views see "Working with Views" at: https://www.youtube.com/watch?v=lpwV3hZDKPs
-
Thank you, Dean! I'm getting started on the video, and I was a place on his screen to have a field type "table" - might that work?
And is there a way (either with views or tables) to parse out the data and put it with the correct record on the main table? Anything other than doing it manually, which I've been trying to avoid for around 5 years!
Thanks for your help!
-
Is it possible that it just took a little while for my data to populate? It looks like it's all there! Magically - I only watched the first few mins of the video and didn't do anything with it yet!
Thank you!
-
Just to experiment, try creating a new "test" database with one table named "Table1" (with one record) and another table named "Table2". Add at least one text field to each table. From within the "Table2" table edit view, drag the "Table1" relation from right to left. That will create a relation link between the two tables. Now open Table1. In the form view you will see the text field for the current Table1, plus a "view" into the child Table2. Click the plus button within the view to add a related record. Now you have a parent record with a related child record. Experiment some more...
Content aside
- 4 yrs agoLast active
- 5Replies
- 1368Views