jpeirce

Hello All: FMP Advanced 9.01 Mac -Published via IWP -I have a database where each record is a city, and carries info such as hotel, contact, travel, meals, etc. for each city (record). -I would like to have people enter info into a record that corresponds to their city. For instance, the hotel would access the record for their city, and be able to enter their phone number, or address, etc. One solution is to break up the database and have a bunch of databases with just one record, then the hotel would go to the home page and click their 'city', and be prompted for Login/Pass. The problem with that is I would have to have hundreds of open databases on my desktop. I don't really like this solution. My "grand plan!" is to have each record generate a random password, then email it to the hotel, and when the hotel enters that password on the webpage, it takes him to the related record. They would only be able to see and edit 'their' record... I can't figure out how to USE the password in the login page. Maybe I could let everyone through the home page, but then the first page of the database is a login page that I build, where I could use the entered number to jump to the related record? Any ideas would be greatly appreciated! JP --

thanks, I get it now. I do appreciate all your help! take care JP

Yes you are correct. I think I was trying to do this too simply. I have changed it, and it works, but not really how I want it to. Set up as you suggest, I work in the PETS (join) table, but this adds records in the OWNERS and PetTypes tables. I would like to do it in reverse, but it doesn't quite work. I basically want to have an owners table, that gets filled in with no specific pet info, and a pet-type table with no specific pet info. Then in a join table PETS, I make records with pet name, pet type, and owner. Then in the portals on the owner table, you would see the name and type of pets each owner owns, and on the PetType table portal, you would see the pet name and owner name of each type. The way it is set up now, I get multiple records of the owner, and pet type. When I uncheck 'allow records creation' I cant enter data into the pets table. It's almost like I have this backwards? Here is my revised file... Thanks for your help, I do appreciate it! JP Pets.fp7.zip

I am a little confused with many to many relationship / join tables. For example: I have a table with pet owner names; and a table with pet types. Each owner can have multiple pet types, and each pet type can have multiple owners. Both are listed with value lists. I would like to be able to choose either an owner and get all the pets they own, or choose the pet type and get a list of the owners. I tried doing this with checkboxes, but it wasn't working, and then with portals and it wasn't working. Can someone take a look at my example and give me a hint as to where I am going wrong? Thanks for your help! JP