I have a database that consists of items, description etc.
For each item I need to have one or more payment processor for it.
eg Credit Card, Check, Money Order etc.
The payment processors need to be user configured so they can have as many of few as necessary + the ability to delete them. I currently have 2 tables set up for this.
Table 1: Items
| Unique ID | Name | ..... other info |
Table 2: Processors
| Unique ID | Name |
I've already done the coding for both the Items and Processors adding/editing/deleting.
I just can't get my head around this. I need to have the Processor ID in the item table somehow. My thoughts were to add like 10 columns to Items and then populate them with the Processor IDs ... but .. this would limit me to 10 only. Not that there may be more than 10 processors, but say there is a particular item that say accepted India Rubbles (I think thats right
I was also thinking of have a 3rd table that links Item ID > Processor ID. But is this the best way or is there maybe something more efficient?
Thanks for any help/ideas/ appreciated