Ok I searched the forums all day and could not find an answer to my problem. I have this folder card that I need to auto-fill info into:

I want to be able to choose my vendor then have the rest of the card populate with data. I cannot do this with Card Lists so i figured there had to be a way to do this with XML and/or EXCEL. Included in the zip folder are my XML files and my excel file I have been working with.

By selecting the Vendor Variable I want the other Variables (VendorContact, VendorEmail, and VendorPhone) to populate from a table.

I already have the variable attributes set to find the xml, but can't figure out if this will work.

Is there a way to do this?

Thanks,

-Clyde