how to generate new record for another table
i want to generate a SEO solution.
i have one table with site informations like:
shop_id shop_name url
then i want to have another table in which i save records for the ranking of that page
shop_id alexa_rank page_rank date
the problem is i want to generate a button on the first table layout that opens a window with a new record that allready has the shop_id and the current date inserted.
i gave my best for 8 hours but no solution untill now.