I have question/problem...I guess you might say it's a which way to best do it.
I have my FM Pro DB (Shoot Info) with records that contains information about photo sights and order numbers. I also have Quickbooks w/a DB (with a QB plug-in). I am pondering the best way to setup FMP7 so that I can call up a FM screen [NEW CUSTOMER] when a new customer calls and put in their information [Name Address, etc...] then save it to QB as a new customer/job and then I will save the photo sight information into the FM DB(Shoot Info). So... I am thinking that global fields should be used for that information that goes to QB and the FM Pro DB(Shoot Info. It makes no sense to have a seperate table that captures the info that goes into Quick Book because then I will have redundant info.
I hope that is clear.
Help...
Comments?...
Thanks,
Robert
I have my FM Pro DB (Shoot Info) with records that contains information about photo sights and order numbers. I also have Quickbooks w/a DB (with a QB plug-in). I am pondering the best way to setup FMP7 so that I can call up a FM screen [NEW CUSTOMER] when a new customer calls and put in their information [Name Address, etc...] then save it to QB as a new customer/job and then I will save the photo sight information into the FM DB(Shoot Info). So... I am thinking that global fields should be used for that information that goes to QB and the FM Pro DB(Shoot Info. It makes no sense to have a seperate table that captures the info that goes into Quick Book because then I will have redundant info.
I hope that is clear.
Help...
Comments?...
Thanks,
Robert