viewing/choosing data from another table-via lookup or ?

[skingjack2]

Hello,

I'm hoping someone can point me in the right direction. The situation is 2 tables, 1 client data the other services. They are related via customer id.

Assuming each client has the potential for more than 1 credit card; how would it be setup up in the services table when the client makes a purchase, I could choose from the client data the the appropriate c/c that was used for payment?

I'm thinking a lookup field might but work but stuck...

Jack

[LaRetta]

I could choose from the client data the the appropriate c/c that was used for payment?

If there can be more than one credit card stored on file, you should have a table of credit cards which would also contain the CustomerID. This customerID would then relate to Services CustomerID and the credit cards could be displayed in portal for selection of the right one.

Having credit cards as a separate table also allows proper encryption or privilege limitation of access to the data which SHOULD be in place on all such valuable data. What would be displayed for general staff would be simply XXX-XXXX-2125 exp. 3/09. This would allow general staff to verify the credit card with the customer and to update the expiration date if expired while still protecting sensitive data.

LaRetta :wink2:

Edited June 27, 2008 by Guest

[skingjack2]

LaRetta,

Thanks for the suggestion... it is now implemented and working fine. I do have a question about the capability of disquising the credit card number as per you your example(simply XXX-XXXX-2125 exp. 3/09). How would one a go about implementing security feature?

Jack

[skingjack2]

Hi,

Just following up on this to see if anyone might have any suggestions or point me in the right direction? Still having issues trying to implement this unfortunately.

Thanks,

Jack

[bcooney]

Create a dsp field that is a calc = "XXX-XXXX-" & right (CCfield,4)

[skingjack2]

Thank you Bcooney...that worked very effectively =)

Jack