Using rules to assign parent/child data...

[ArgentAJ]

I may be over-thinking this, but...

 

Our customer wants their employees to order business cards online. But, to make sure all information is correct, they want to work from a master spreadsheet of information. Basically, the buyer would enter his/her employee number and all info would populate behind the scenes.

 

I know this can be done using Parent/Child settings in the Define HTML section. But, it requires using a pick-list for the parent. There will be over 800 users, so that's too cumbersome. Plus, just assigning all that data would take forever.

 

Is there a way to write a rule that will (after the buyer enters his/her employee number) assign values to address fields and phone number fields? Then use that data to populate the PDF.

 

Sorry for the novel. I'm just having a hard time wrapping my head around the workflow.

 

Thanks a bunch for any pointers!

Adrian