Jump to content

2 masters - 1 child?


This topic is 7832 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm using an invoicing/line items scenario. There is also another file for booking of equipment, which may or may not turn into an invoice later on. It's line items file is virtually identical to the invoicing line items file. So the question is, can't i just use the same line items file for two master files? There would be a few redundant fields in each record, depending on which master file was used to create the child record, but that shouldn't be a problem. The relational key should be enough to keep these records separate, shouldn't it? Seems to me that it would make importing easier and one less file to manage.

Link to comment
Share on other sites

It is certainly possible. I do that with a Notes file. Many of my objects support the addition of any number of arbitrary dated notes. Rather than numerous files, I implemented this with one Notes file; each record has four fields, ID, Date, User, and the Note text. The ID is the ID of the record it corresponds to prefixed by the filename.

This works great when you primarily access the child file from the various master files. Accessing the master files from the child file would be kludgy and not particularly extensible... but possible.

Link to comment
Share on other sites

This topic is 7832 days old. Please don't post here. Open a new topic instead.

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...

Important Information

By using this site, you agree to our Terms of Use.