Hi can someone help
I have a form with 2 list boxes on it.
Each list box has a list of stuff (doesn't matter what really)
I have a new table set up as a link entity like so
pk_aprimarykey - A replication ID primary key autonumber field
fk_1 - Replication ID
fk_2 - Repliaction ID
What I need to do is every time I click a button is to
make a new record that assigns the replication ID from the first list box to fk_1 and the same for fk_2 from the second list box
basicly i'm trying to populate a many to many link entity table, but I don't know how to pass the replication id (or how to add a record using VBA).
Can anyone help me thanks in advance
I have a form with 2 list boxes on it.
Each list box has a list of stuff (doesn't matter what really)
I have a new table set up as a link entity like so
pk_aprimarykey - A replication ID primary key autonumber field
fk_1 - Replication ID
fk_2 - Repliaction ID
What I need to do is every time I click a button is to
make a new record that assigns the replication ID from the first list box to fk_1 and the same for fk_2 from the second list box
basicly i'm trying to populate a many to many link entity table, but I don't know how to pass the replication id (or how to add a record using VBA).
Can anyone help me thanks in advance
