MattBaldry
Self Taught, Learn from the Forums
- Local time
- Today, 07:15
- Joined
- Feb 5, 2019
- Messages
- 293
Just after a little advice in case anyone has ever built something like the subject line.
I have done a few different ones and have always had a separate table for customers and suppliers. I have started to notice that some people have a customer who is also a supplier. Would there be any benefit in having a single table and a field that allows to be either customer, supplier or both?
Or would it be better practice to continue with the trusted method I already base this on?
~Matt
I have done a few different ones and have always had a separate table for customers and suppliers. I have started to notice that some people have a customer who is also a supplier. Would there be any benefit in having a single table and a field that allows to be either customer, supplier or both?
Or would it be better practice to continue with the trusted method I already base this on?
~Matt