Jump to content

Could the database and grid support creating a People Table?


Fred Slota

Recommended Posts

Database efficiency and consistency could/would be improved by replacing the text fields of Artist, Writer, Cover, etc, with a linked Person Table.

 

But, does the database and grid support a field with a variable number of references?  A text field can easily record that the writers are "Joe Smith, John Jones", but can the database and grid record in one field that the writers are Person-12345 and Person-67890, and resolve those to "Joe Smith" and "John Jones"?

 

I guess I'm asking if modern databases and the CB database supports a Table element that is an array?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...