picnichouse Posted January 21, 2005 Share Posted January 21, 2005 Hi, I'm trying to map a bunch of fields to another set of fields with different names. The way I thought I'd do this is to make two tables and create relationships between the synonomous fields. I'd like it so that when I add a record in one table, it automatically creates that record in my new table. For example, I have two tables, "apple orange cucumber banana" and "orange yello green red" So I make the relationships apple = red orange = orange banana = yellow cucmber = green And I checked "Allow creation of records in this table via this relationship" and "delete records in this table via relationship" for both boxes. What else do I have to do? By the way, the reason I'm doing this is to remap the headers for the invoice export from my web store to my local accounting software. Thanks! Link to comment Share on other sites More sharing options...
This topic is 6641 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now