Let me start off by saying I assume that Cobalt Types are really database tables and Type Fields are actually fields/columns in a table.
I am building a system that requires a one-to-many relationship between tables. For the sake of example, I want to create a Type called "Customer" with fields like Customer Number (unique), First Name, Last Name, Address, etc. I create another Type called "Payments", which contain fields like Customer Number, Payment Type, Payment Amount, etc.
How do I create a form that allows the user to choose a customer from a list of Customer records? I'd like to use a text field that suggests as the user types (AJAX) or at least a dropdown field (although with hundreds or thousands of customers, that could be too much).
How can I create a page that filters ONLY Customer records a user enters and not records that other users have entered?
Let me start off by saying I assume that Cobalt Types are really database tables and Type Fields are actually fields/columns in a table.
I am building a system that requires a one-to-many relationship between tables. For the sake of example, I want to create a Type called "Customer" with fields like Customer Number (unique), First Name, Last Name, Address, etc. I create another Type called "Payments", which contain fields like Customer Number, Payment Type, Payment Amount, etc.
How do I create a form that allows the user to choose a customer from a list of Customer records? I'd like to use a text field that suggests as the user types (AJAX) or at least a dropdown field (although with hundreds or thousands of customers, that could be too much).
How can I create a page that filters ONLY Customer records a user enters and not records that other users have entered?