Search results

Yes, you are right. I am sorry, I over-reacted. It just seemed you were picking me apart rather than helping. I like the idea of the junction table. I'm not sure how to implement it though. I'd have a bunch of ID#'s needing to be linked to the same information..I have a feeling there's a query...

I do not have any control over the tables. Though I could probably get it if I had a good solution.

Yes! :) That's right. Just I want the ID# to be different from the previous record.

Don't tell me the design is flawed. I don't want to be told about how the design is flawed. That's not my job. My job is to make it work. So either help or be quiet. It's version data. It's exactly the same except for the version number.

Yes, the tabs/subforms are all linked with an ID#. I want to increment/change the ID# on the new set of tabs/subforms and then copy all the remaining information.

They are subforms to be able to use additional tables.

I have a record which has tabs. And I was to copy the whole record into another one. The problem I'm coming across is, I'm only getting it to copy the first tab such that the new record only has one tab with the information on the first tab of the old record. I want the new record to be exactly...

I have a form/record with multiple tabs and I want to copy it into another form keeping it exactly the same, with all the tabs the way they are and all the information intact. I've been able to copy the first tab, but I can't get any of the other tabs to copy.