Jump to content
Sign in to follow this  

pulling data from one table to another - prob solved :)

Recommended Posts

this is prob easy, but aren't all things when you know how : ... i've got a database which has an area for taking notes (like for phone conversations, etc) has about 6-8 fields - client name, client ID, phone number, note reference (title), the note itself, called by, created date ...

http://jleeinc.com/sma/note.jpg - screenshot

and from there, i want to be able to pull specific data to essentially a list view of activity for a specific day :

http://jleeinc.com/sma/callbackreport.jpg - screenshot

i'm not sure how to grab the data for a specific date ... do i need scripts to call for the client ID, client name, note ref, and created date to match the date specified?

hopefully i'm not being too confusing ... basically in english its, show all records (displaying the fields: client ID, Client name, Note reference, and Created Date) for "this specified" date ... i'm just not sure how to create the script to do that ...

any help is more than appreciated !

if more clarification and/or screenshots are needed, please advise, i'll be happy to add more ..


Edited by Guest

Share this post

Link to post
Share on other sites

Why not relate the two tables together, using the date field, and display the data in a portal?

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.