I have a form with
CategoryID - frn key
ProductID - frn key
DateAcquired - enter date
StatusID - frn key
TxtN - unbound text box
create - button
openform - button
The idea is to fill out all those fields and on clicking create, txtN (unbound txtbox) amount of records with identical catid...