gilles

Hello Ryan and thank your for your welcome advices. I'm playing with PW and trying to get it to work according to my needs and (most important) my limited knowledge. Will play more and, if interested to get involved, come back later for more practical questions. You show me the me the right direction, fine ; I need to do testing on little data to understand better how it works and how I can use it. Custom fields and templates are usefull. (not 200k pages, in my case : main pages are for words --55k-- ; connecting to quotes and more, sort of dictionary). Gilles.

Hello ! First post I am interested in PM wich could be a pertinent tool very close to what I need (because of custom fields and template). Demo file installed and working. It looks sincerely interesting and attractive. As of now, I'm confused about many things (mostly how to connect data). My purpose is to run an online dictionary, quite big. Same kind of work as Skyscrappers demonstration (many data connected, many fields working as filters) I guess. My online site is designed this way (quick resume) : table words (55000 items) : id_word word variant meaning table quotes (200000 items) : id_quote id_word quote year_quote A few other fields and tables (synonyms...) ; but it's enough for my questions. What would be the classic/usual strategy to get this data run by PW (I will not create the data inside PW : I use microsoft Access daily, then I update the online database once a year, more or less) ? Do I have to create a field by myself for every information taken from all tables ? I guess yes ? What about the id fields ? In my current database, they are used for connecting the relevant data together and I need to keep them accessible and usable them to get final url like ..../word/23445 (where 23445 is id of word 23445 of course). Say I create several fields (word, variant, meaning, quote, year_quote) : then what to do with my id fields ? then how does PW connect the data ? I may be unclear, sorry for that. If needed, please tell me what to correct. I'm not asking light about how to show informations (templates) --will come next--, but how to import data and how to get working connections (more database related). Thank you