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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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