Item > Category help
Posted: Thu Mar 26, 2009 6:48 am
Hi all,
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
) ... so they may need to add Rubles to the processors yet only use it for one item. I wanted the flexibility of having virtually unlimited Processors.
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
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