December 23, 200322 yr Can someone point me in the right direction for this. I have a database with 562 records in it and I want to enable the web companion so that people can log in from a web browser and see only about 23 of those records in form view. The 23 records that I want them to be able to see are for a winter tour coming up. I only want them to be able to see them as a report and not be able to search or enter any data (I can figure that part out). I can create a flag field for marking the records that I want displayed but I am not sure where to go from there. I also want the number of records shown to be dynamic based on whether or not I flag them. It seems to me that the best way to do this is to create a related database that has just the fields that I want them to see and have a script so that when I flag a record in the original database it automatically creates a new related record with the correct data in the correct fields in the related database that can then be served up over the web companion but I am not sure how to go about this. I mean, I know how to create a relationship but I am not sure about how to make a script that would create a new record in the related(web) database whenever I flag a record in the original database. Please help. Ronzues
Create an account or sign in to comment